Re: Force index usage

Posted in 1997

Greg — Thu, 22 May 1997 23:13:18 -0500 — source: Informix-list mailing list archive (1991-1998)

I've found that adding distributions to an index frequently would "push" the optimizer in the "right" direction, i.e. the way I wanted it to go. With the extra info distributions provides, the optimizer could then see it my way... Greg Tim Kelly wrote: > > Ok, how in 7.x can I force an index to be used in an SQL Select statement? > > Thanks