Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Setting Index at the time of selecting records
Message
From
23/05/2001 05:50:18
 
 
To
All
General information
Forum:
Oracle
Category:
Other
Title:
Setting Index at the time of selecting records
Miscellaneous
Thread ID:
00510232
Message ID:
00510232
Views:
38
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
Map
View

Click here to load this message in the networking platform