Order by question - newbie

[Csillag Zsolt]

Hi,

I have a table with 3 colums :  PersonalCode,  Name and  SpecialOrder.

The PersonalCode is the primary index and I have also an index  on SpecialOrder,Name columns.

However the following select:

Select PersonalCode From MyTable
  Order By SpecialOrder,Name

doesn't use the  SpecialOrder,Name index at all.
If I watch it in Explain Plan window I can see that :

SELECT STATEMENT, GOAL = CHOOSE                 1181    16378   2456700
 SORT ORDER BY                  1181    16378   2456700
  TABLE ACCESS FULL     ADMIN   MyTable 69      16378   2456700

How can I make the index work?


Thank you in advance

Zsolt Csillag
Hungary