Hi
I have table student with index built upon it naming index1 ,index2 so on
and so forth.
I want to write a query by which i can force the optimizer to use the
specified index.
Somewhat like :
select * from student use index(index1).
Is there any way to achieve this
Regards
Naman