Kbase P83083: Query takes a long time to execute
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
6/4/2004 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1D
SYMPTOM(s):
Query takes a long time to execute
Removing all records from the SYSIDXSTAT table resolves the problem
CAUSE:
Bug# 20040415-017
CAUSE:
The query optimizer incorrectly handled restrictions on IN predicate support for a join using an index correctly
FIX:
Upgrade to Progress 9.1D09 (Service Pack 9) or later