Kbase P112102: Slow performance with simple SQL92 select statements when database contains hundreds of tables
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
12/27/2005 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1E
Progress 9.1D
SYMPTOM(s):
Slow performance with simple select statements
Query plan shows full table scan
Database contains hundreds of tables
Using primary index lead component in the WHERE clause
CAUSE:
Exceeding index statistics structure limit
FIX:
Upgrade to OpenEdge 10.0B or 10.1A.
The workaround is to use ranges and/or like phrase instead of equality matches for index leading components.
Examples:
The original query is: SELECT * FROM PUB.customer WHERE name = "Lift Tours"
The optimized query will be: SELECT * FROM PUB.customer WHERE name LIKE "Lift Tours%"