SQL92 Optimizer - Hit or Miss?

IanLeslie

New Member
Are we the only people having problems with the SQL92 optimizer choosing poor table join order and index usage on queries involving more than five tables with volume data and compound indexes, or are Progress not quite telling us the truth.
We are running queries against a Progress 9.1B04 database running on a AIX server and experiencing poor performance of SQL92 queries for all but the simplest of queries and selection criteria. Analysis seems to show that good index selection is only partial and complete table scans are occurring on some tables. We have run the update statistics command for all tables involved in the queries but still fail to get good index optimization.

We are still waiting for a patch to fix the Between predicate which currently causes table scans although this is apparently a 'Product Enhancement'!!!

Any feedback and advice would be appreciated.
 
Top