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: Jining Han <jining.han_at_gmail.com>
Date: 16 Feb 2006 13:02:56 -0800
Message-ID: <1140120899.898594.127740@z14g2000cwz.googlegroups.com>

and CACHE is not an issue? What if you run the two (DESC first then ASC) back to back?

JH Received on Thu Feb 16 2006 - 15:02:56 CST

This message: [ Message body ]
Next message: Verner Jensen, Ålborg: "Re: Running Interconnect on XE?"
Previous message: Marc Blum: "INSERT...SELECT...FROM TABLE(object-collection) slow"
In reply to: VIC: "Re: query slower using order by asc (default index order) than oder by desc"
Next in thread: Jonathan Lewis: "Re: query slower using order by asc (default index order) than oder by desc"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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