Kbase P117875: SQL: Optimizer to choose a non-optimal index or perform a table scan resulting in poor performance.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
1/1/2009 |
|
Status: Verified
SYMPTOM(s):
SQL: Optimizer may choose a non-optimal index or perform a table scan resulting in poor performance.
Executing a query where a table index with more than 10 key components is a possible index usage candidate for the resolution of the query.
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge 10.0B
OpenEdge 10.0B05
CAUSE:
Bug# OE00131082
CAUSE:
Incorrect internal index statistics usage when an index with more than 10 key components is a possible candidate causing the SQL Optimizer to choose a non-optimal index or perform a table scan resulting in poor performance.
FIX:
Upgrade to OpenEdge 10.1A02 or higher