Re: select index ???

Posted in 1998

Art S. Kagel — Wed, 20 May 1998 18:11:04 -0400 — source: Informix-list mailing list archive (1991-1998)

Serg Shejkin wrote: > > Hi everyone ! > > We have Informix 7.23.FC1 for DEC Alpha. > How to force Informix to use an index " sl1 _ wrk _ b200 _ 5 " > Instead of " sl1 _ wrk _ b200 _ 3 " [SNIP] Can't do it in 7.23. In 7.24 you can SET OPTIMIZATION FIRST_ROWS and the optimizer will TEND STRONGLY to use an index that matches the ORDER BY clause. In 7.3 you can do that or us OPTIMIZER HINTS to specify which index to use. Version 7.23 has neither feature. Art S. Kagel