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.