Re: Force index usage

Posted in 1997

Stefan — Mon, 23 Jun 1997 16:37:13 -0100 — source: Informix-list mailing list archive (1991-1998)

David Williams wrote: > > In article <5mhoc2$g0c@news.informix.com>, Amitabh B Sinha > <amitabh@informix.com> writes > >The next release of ODS and IUS will include a feature called > >directives, which will be a non-ANSI compliant way of directing > >the optimizer to do things it would not do in normal circumstances. > >The current set of directives include the following: > > forcing index selection, > > forcing full-table scans, > > forcing join method selection > > forcing join order > > etc. > > > >Amitabh Sinha > > Where did this info come from ? > > -- > David Williams It's from the Informix Technical Conference '97. Bye Stefan