Re: index never used

Jesús Marín wrote:
>
> I have a table indexed by name and indexed by code. Code is a numeric
> item and name a varchar2(30).
> As I use "select * from table order by code", it works fine using the
> appropiate index but as I order it by name, it always makes a sort as I
> see in the plan.
> Anybody knows why?

There may be differences in cardinality and/or blocks in the respective indices. Maybe try a hint.

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse