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;
