Re: query order clause and indices

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

Other related posts: