【openGauss】openGauss强制走索引的hint写法，单独在表的select里面加

---

select /*+ indexscan(t1 idx_tzq_log_6) */
       sum(t1.read_amount) as read_amount
      ,t1.log_code as log_code
  from tzq_log_t t1
 inner join (select /*+ indexscan(t2 idx_tzq_log_read_user_6) */
                    distinct t2.log_id
               from tzq_log_read_user_t t2
              where t2.enable_flag = 'Y') t
    on t1.log_id = t.log_id
 where t1.enable_flag = 'Y'
 group by t1.log_code;