Kbase P25566: SQL-92: UPDATE STATISTICS causes performance degradation
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
1/31/2005 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1D
SYMPTOM(s):
UPDATE STATISTICS causes performance degradation.
Performance is slower after running UPDATE STATISTICS.
CAUSE:
Bug# 20030521-004
FIX:
Upgrade to Progress 9.1E / OpenEdge 10.0B or above.
- OR -
Undo the changes by running the following query:
DELETE FROM sysprogress.systblstat;
- OR -
You can also use {NO REORDER} in the FROM clause to get better performance.