Tagged Questions
1
vote
2answers
993 views
oracle order by runs terribly slow
i'm doing a query like this one and it takes 6 seconds to complete :
select *
from ( select aaa."ID"
from "aaa"
where aaa."DELETED" is null
order by aaa."CREATED" desc )
where ...