where displ_date between to_date('2006-5-30 8:00:00','yyyy-mm-dd hh24:mi:ss')
and to_date('2006-5-30 17:30:00','yyyy-mm-dd hh24:mi:ss')
还有一些其他条件,这样查询反应很慢啊,请问有没有什么好的办法
select * from orders a
where a.order_type_id = 3 and a.displ_date between to_date('2006-5-30 8:00:00','yyyy-mm-dd hh24:mi:ss')
and to_date('2006-5-30 17:30:00','yyyy-mm-dd hh24:mi:ss')
当然,还join了其他一些表
select * from inte_order io
join job_spec js on js.job_spec_id = io.job_spec_id
join crm_for_sa cfs on cfs.order_id =io.order_id
where cfs.area_id =75 and cfs.sts ='N'
and io.job_spec_id = '000030'
and io.displ_date between to_date('2006-5-30 8:00:00','yyyy-mm-dd hh24:mi:ss')
and to_date('2006-5-30 17:30:00','yyyy-mm-dd hh24:mi:ss')
select * from inte_order io
join job_spec js on js.job_spec_id = io.job_spec_id
join crm_for_sa cfs on cfs.order_id =io.order_id
where cfs.area_id =75 and cfs.sts ='N'
and io.job_spec_id in ( '000030','000040')
and io.displ_date between to_date('2006-5-30 8:00:00','yyyy-mm-dd hh24:mi:ss')
and to_date('2006-5-30 17:30:00','yyyy-mm-dd hh24:mi:ss')