I'm not sure what you mean by using a particular index.
If you want the index to be used to order the records, just add and ORDER BY line to the query:
SELECT * FROM student
ORDER BY index1.
On Saturday, October 19, 2013 8:24 AM, Naman <naman(dot)bbps(at)gmail(dot)com> wrote:
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