回滚段TO_TIMESTAMP及HINT

一、回滚段查询

SELECT *
  FROM t_od_tf_recv_queue_his AS OF TIMESTAMP TO_TIMESTAMP('2016-03-08 12:38:17', 'YYYY-MM-DD HH:MI:SS')
 where tf_number = '82321959';

SELECT *
  FROM t_ms_event_pool AS OF TIMESTAMP TO_TIMESTAMP('2017-11-10 16:00:17', 'YYYY-MM-DD HH24:MI:SS')
 where proc_inst_id in (201711081496730);

　　 

二、HINT

SELECT * FROM tin_ims_tab A WHERE A.DEAL_STATE IN('S', 'F') and sheet_no<900000000000001 AND rownum<=:1 order by a.sheet_no

优化建议：修改sql,加hint:
SELECT /*+ index(a IDX_DEAL_STATE) */ * FROM tin_ims_tab A WHERE A.DEAL_STATE IN('S', 'F') and sheet_no<900000000000001 AND rownum<=:1 order by a.sheet_no