Re: Query Optimiser

Posted in 1993

Joerg Spilker — Mon, 25 Oct 1993 19:57:08 MET — source: Informix-list mailing list archive (1991-1998)

Hi Richard, RR> reasons. Usually, however, we have checked the code and discovered RR> that if you re-arrange it more logically, the optimizer decides to RR> use the index. i made the experience that an ORDER BY can also force the optimizer to use the index (even if the columns need not to be sorted). Greetings, Joerg