oracle sql优化的问题 各位大神有什么办法优化一下吗

Question

SELECT a.JIAODU_X AS "xPoint", a.CAIJITIME AS "yPoint", a.SENSORNO AS "sensorno", a.SENSEID AS "sensorid"
FROM WM_DRAWPONIT_DB a where a.CAIJITIME > =to_date( '2017-05-28 14:50:16','yyyy-mm-dd hh24:mi:ss') and
a.CAIJITIME < =to_date('2018-01-22 14:06:08','yyyy-mm-dd hh24:mi:ss') and
a.SENSEID ='a9b78b7a524843be87b254303b3c8bb1' order by a.CAIJITIME
加上时间排序后非常的慢 要20多秒

加上时间排序

去掉时间排序

各位大神有什么办法优化吗 小弟对sql不太懂

Answer 1

SELECT
a.JIAODU_X AS "xPoint",
a.CAIJITIME AS "yPoint",
a.SENSORNO AS "sensorno",
a.SENSEID AS "sensorid"
from(select
JIAODU_X
CAIJITIME
SENSORNO
SENSEID
FROM WM_DRAWPONIT_DB
where CAIJITIME > =to_date( '2017-05-28 14:50:16','yyyy-mm-dd hh24:mi:ss')
and CAIJITIME < =to_date('2018-01-22 14:06:08','yyyy-mm-dd hh24:mi:ss')
and SENSEID ='a9b78b7a524843be87b254303b3c8bb1' )a
order by a.CAIJITIME