Re: Force index usage

Posted in 1997

David Williams — Mon, 23 Jun 1997 22:26:55 +0100 — source: Informix-list mailing list archive (1991-1998)

In article <33AEB449.277BAA9D@weideneder.de>, Stefan <stefan@weideneder.de> writes >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 What was this? What other info was given out then... Come on Tim....Where are you?.... -- David Williams