Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: query slower using order by asc (default index order) than oder by desc
Yes the difference between those two queries are just response time
(sorry for the ambiguous description)
And you are right. This table has been purged twice before (each purge deleted about 5 million rows) and the index hasn't been rebuilt after the purge. I just re-built the index and the bottom up query went fine.
Thank you very much for your help and also everyone else who replied this thread.
-Vic Received on Fri Feb 17 2006 - 19:55:53 CST