SELECT min(consumedate)
FROM (SELECT motoid, condate
FROM rides
WHERE motoid = '00001'
ORDER BY condate DESC) goods
WHERE rownum < 6
表 goods(motoid,condate,........)怎么建索引这个查询才得上?
...全文
1095打赏收藏
建索引,马上揭贴
SELECT min(consumedate) FROM (SELECT motoid, condate FROM rides WHERE motoid = '00001' ORDER BY condate DESC) goods WHERE rownum < 6 表 goods(motoid,condate,........)怎么建索引这个查询才得上?