同样的sql只有查询的日期不同但执行速度相差很多

Question

SELECT message,status,receivername,main.registno,sendername,to_char(send_time) as send_time,mobile,riskcode
from prplflsmssend ps left join prplflsmslog pl on pl.smssendid=ps.id, prplflmaininfo main
where trim(smstype)<>'' and pl.registno = main.registno and smstype='35'
and exists ( select pdrc.comCode from PrpDcompany pdrc where ( pdrc.upperPath like '00000000,42000000,42010000%' ) and main.comcode = pdrc.comCode )

and operatedate between to_date('2015-09-04 00:00:00') and to_date('2015-09-04 23:59:59') ; --执行速度 大约30分钟

select message,status,receivername,main.registno,sendername,to_char(send_time) as send_time,mobile,riskcode
from prplflsmssend ps left join prplflsmslog pl on pl.smssendid=ps.id, prplflmaininfo main
where trim(smstype)<>'' and pl.registno = main.registno and smstype='18'
and exists ( select pdrc.comCode from PrpDcompany pdrc where ( pdrc.upperPath like '00000000,42000000,42010000%' ) and main.comcode = pdrc.comCode )

and operatedate >= to_date('2015-09-09 00:00:00') and operatedate<= to_date('2015-09-09 23:59:59') 执行速度 几秒钟

Answer 1

执行查询计划，看慢到哪里了！