Re: How to force use of an index.

Posted in 1996

Joseph Kormann — Wed, 02 Oct 96 03:36:48 GMT — source: Informix-list mailing list archive (1991-1998)

In article <324C6310.5593@worldnet.att.net>, Steve Proctor <Steve.Proctor@worldnet.att.net> wrote: >Online version 5 > >I've got a very slow select wihch I've analysed using set explain on. > >I know it would be quicker if I could force it to use a particular index >for it's main index path. > >Any ideas how to force the optimiser to use an index? I'm interested in this (if possible) too. Anything? -Joseph