As far as I know you don't ...
You instead select the data that would use this index by specifying the correct where clause...
i.e.
oCommand=CREATEOBJECT("ADODB.COMMAND")
oCommand.addparameter('emp_id',adchar,emp_id_size,emp_id_Val)
.
.
oCommand.commandtext='select * from Employee_Mst where emp_id=? and emp_join_date=?'
oRecordSet=oCommand.execute()
You're index might not even be used depending on the optimizer.
It is more likely to use it if you create three seperate indexes non-composite:
index on Emp_Id
index on Emp_Join_Date
index on Emp_Name
Otherwise you would have to write the query as:
'select * from Employee_Mst where emp_id||emp_join_date=?'
Which is not that good for index size and usablity..
HTH
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement