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不太懂