Re: Force index usage

I have found that in at least one instance, I can force Informix to us a certain index by dropping the index and recreating it. Subsequent queries will use that index until the next time statistics are updated. Then it reverts back to the optimizer's less than optimum choice. Larry Foote Douglas Wilson <dgwilson@gte.net> wrote: >Jacob Salomon wrote: >> >> Tim Kelly wrote: >> >> > Ok, how in 7.x can I force an index to be used in an SQL Select >> > statement? >Although you can't force usage of a certain index, you can force >non-usage >of an index you don't want to use, thereby (hopefully) causing the >optimizer to use the index you do want to use. Which may or >may not satisfy your needs. >Douglas Wilson