Re: Force index usage

Posted in 1997

Douglas Wilson — 22 May 1997 23:58:51 GMT — source: Informix-list mailing list archive (1991-1998)

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