Hi,

i am using ORACLE as a back - end for my VB application
in ORCALE i have a table say Employee_Mst with the following indexes
index on Emp_Id
index on Emp_Id + Emp_Join_Date
index on Emp_Id + Emp_Join_Date + Emp_Name

i want to open a recordset in VB using the 2nd index (i.e. Emp_Id + Emp_Join_Date ) for seeking purpose

where should i define which index i want to use while opening a recordset

pls tell me

Thanx in advance,
Amol