Re: Force index usage

Posted in 1997

David Williams — Thu, 29 May 1997 21:07:35 +0100 — source: Informix-list mailing list archive (1991-1998)

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 A new face at Informix joins c.d.i. Welcome! Thanks for the info. Seems a bit more comprehensive than our competitors!! -- David Williams