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

Try setting OPTCOMPIND (in the onconfig file) to 0, instead of the default 2. -- ============================== pmosser@minisoftinc.com Paul A. Mosser, Developer/DBA MiniSoft, Inc. Phoenix, AZ U.S.A. } -----Original Message----- } From: alan.cowan@autodesk.com [SMTP:alan.cowan@autodesk.com] } Sent: Wednesday, August 06, 1997 9:38 AM } To: informix-list@rmy.emory.edu; Alastair Kimbell } Subject: Serious Flaws in 7.23's Optimizer - Not using indexes } } In a nutshell: } The Optimizer does not usee indexes even if EVERY join is an } indexed } field. } Lots of problems in other examples including every time I use } EXISTS it } does a SEQUENTIAL search where an index is available. } Informix 5 did not have these problems. } } [snip] } } Wish I were back with v5 } } Alan Cowan