Kbase P11354: Database engine fails to use the best index
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
30/05/2006 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1D
SYMPTOM(s):
Progress 9.1D05
Database engine fails to use the best index
Progress may choose different index for the same query when run under OpenEdge 10.0x than when run under Progress 9.x
Database engine ignores a second or third (not first) BY DESCENDING phrase to choose best index
Query/FOR EACH has no where clause or the where clause should not influence the choice of index
CAUSE:
Bug# 20021022-001
CAUSE:
Bug# 20020225-009
FIX:
A series of database engine optimizations have been implemented. Some of these optimizations, fixes, could cause some queries to select an index when run under OpenEdge 10.x that is different from the index it selects when run under Progress 9.x.
Use the USE-INDEX option to force Progress the use a specific index