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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: query order clause and indices

Re: query order clause and indices

From: David <thump_at_cosmiccooler.org>
Date: Wed, 8 Dec 2004 14:33:32 -0800 (PST)
Message-ID: <1496.64.37.153.21.1102545212.squirrel@64.37.153.21>


I tried adding the index and using the order by with predicate additiona, but LIO's then jump back up to 50,000 abd sorts is performed:

 create index rep.junk on rep.items(MASTERY_SKILL_LEVEL) online;

 AND item0_.mastery_skill_level > 0

              ORDER BY item0_.mastery_skill_level)

-- 
..
David

 Also, there are scenario's where Oracle can

> see an order by clause and recognise that a particular index has already
> ordered the results that way - in this scenario is doesn't always need to
> perform the sort operation. The beauty of this approach is that it works
> efficiently normally but even if something happens to the index then your
> result set is still valid - it will just take longer.
-- http://www.freelists.org/webpage/oracle-l
Received on Wed Dec 08 2004 - 16:33:07 CST

Original text of this message

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