Re: select index ???

Posted in 1998

David Kosenko — Wed, 20 May 1998 21:19:27 GMT — source: Informix-list mailing list archive (1991-1998)

"Serg Shejkin" <embod@mail.wplus.net> offerred: +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 " Upgrade to 7.30 and use the optmizer directive feature. Otherwise there is no way to "force" the optimizer to use one index over another. Updating statistics, possibly at high level for the columns contained in the index, might result in a different index being chosen, but that is not guaranteed. Rewriting the query is another possibility, but is often difficult without changing the results you want to get back. -- Dave Kosenko davek@summitdata.com Director of Training Services (732) 469-4070 Summit Data Group (an Informix Authorized Education Center)