Re: forcing index use with OWS/NT

I have no hands on with workgroup server, but I've found that with Online, if the optimizer is making a bad decision, it's almost always (99%) because the stats are either non existant, or more likely not detailed enough for the optimizer to be able to tell what to do. I'd look into the "update statistics" SQL statement. Specifying the index to use is a kludge you have to do with Oracle because no amount of stats will help it... ;-) Greg Thomas Lankes wrote: > snip optimizer doing the wrong thing description.... > Hi, > > it is a standard informix-problem. The Informix optimizer does sometimes > mysterious things ... > > If you've got OWS 7.3x or higher you can use the new SQL-Command "USE-INDEX" > and name the index you want to use. > If you have not: Try Reading the complete record or first read another field > that is not part of an index > > Best regds. > Thomas > Thomas.Lankes@t-online.de