Re: Serious Flaws in 7.23's Optimizer - Not using indexes

Posted in 1997

David Williams — Sat, 9 Aug 1997 00:11:11 +0100 — source: Informix-list mailing list archive (1991-1998)

In article <5sd3hl$sfc@cssun.mathcs.emory.edu>, Dianne Pendleton <dianne.pendleton@autodesk.com> writes >Thanks to everyone who has been trying to help us with this problem. >Alan's post was misleading, if not inaccurate. >The steps outlined below are exactly what we are doing. And I have tested >the sql right after running the correct set of update statistics. From >looking at the sql, I believe we have just hit upon the problem with the OR >clause forcing us to use UNION. This was mentioned in several other emails >in the last couple of weeks. Someone said that the OR's used to work in >version 4 of ISQL, but not in version 6. Does anyone know if Informix >considers this a bug or if we just have to use UNIONS now? > Informix do not consider this a bug, you just have to use UNIONS now. -- David Williams