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

Posted in 1997

Cosmo Lee — Thu, 07 Aug 1997 11:56:27 -0700 — source: Informix-list mailing list archive (1991-1998)

Make sure you've run "update statistics" on all tables in the query. I've found that if the statistics are not current, the engine will ignore indexes, especially if the tables are new. -- * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ADDRESS ALTERED TO FOIL SPAMMERS: Remove "*NO-SPAM*" to reply. Cosmo Lee Multi-User Computer Systems Brooklyn, NY "JUST SAY 'NO' TO SPAM" * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *