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