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
"VIC" <victorcy_at_gmail.com> wrote in message
news:1140227753.705334.36490_at_g43g2000cwa.googlegroups.com...
> 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
>
I don't think you had to rebuilt the index - a recompute of the index
statistics should be enough.
But, a rebuild will free up some diskspace too.
Matthias Received on Sun Feb 19 2006 - 05:28:03 CST