ORACLE时间段查询优化的问题？

试试下面语句：SELECT SID, SSJSID, RQ, SJ FROM JING_SS Where to_char(rq,’yyyyMMdd’) between 最先日期 and 竣事日期 and not to_char(sj,’hh24mmss’)竣事时间and to_char(rq,’yyyyMMdd’)=竣事日期 and ssjsid in (select sid fromcom_dw connect by prior sid=fid start with sid=单元编号) Order by sid;