General information
Title:
Setting Index at the time of selecting records
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only