Re: Indexing

In article <2t9rds$4fo@stargate.promus.com>, Jim Burks (jburks@promus.com) writes: > >Note: I didn't have Duc's original question around to answer, but >one way to "force" the optimizer onto a specific index is to use >ORDER BY. If you want the optimizer to use index i_1, then >append ORDER BY f_1, f_2 to the query. > >~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ >~ Jim Burks jburks@promus.com ~ >~ Database Administrator / Systems Engineer ~ >~ The Promus Companies, Inc. Memphis, TN USA ~ >~ http://stargate.promus.com/public/jbb.html ~ >~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > Due to a glitch in the informix Online 5.02 optimizer this sometimes doesn't work ! Informix support in the Netherlands told me it will be fixed in version 5.03 but they couldn't tell me when this version will be released. Eelco. Uniware Computer Systems BV