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.
John Bunn — — source: Informix-list mailing list archive (1991-1998)
Has anyone noticed the 5.X optimizer making bad choices when choosing a query plan?
In my case the optimizer insists in performing a sequential read of a detail table
ignoring the unique index used to join to the master. Performance, as you can
imagine is very, very poor.
Informix has not given us information as to whether this is a known bug, but they
seemed supprised. I've seen it in several different forms over the last month or
so, and I wonder how many other people have the same experience...
JB
Your privacy choices
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.