Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Greg — — source: Informix-list mailing list archive (1991-1998)
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
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.