Tikshya
asked on
Forcing Informix to use index
Is it possible to force a SQL statement to use a particular index in Informix Database?
We have a scenario like this:
There are two indexes on a table. Informix optimizer by default selects one index while executing that query. Is it possible to make Informix use the other index on the table for that query ? If yes, how ?
I have Informix 7.30 on HP-UX.
We have a scenario like this:
There are two indexes on a table. Informix optimizer by default selects one index while executing that query. Is it possible to make Informix use the other index on the table for that query ? If yes, how ?
I have Informix 7.30 on HP-UX.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.