Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: query slower using order by asc (default index order) than oder by desc

Re: query slower using order by asc (default index order) than oder by desc

From: VIC <victorcy_at_gmail.com>
Date: 17 Feb 2006 17:55:53 -0800
Message-ID: <1140227753.705334.36490@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 Received on Fri Feb 17 2006 - 19:55:53 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US