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