Information

Title	SQL-92: UPDATE STATISTICS causes performance degradation

URL Name	P25566

Article Number	000151537

Environment	Progress 9.1D All Supported Operating Systems

Question/Problem Description

SQL-92: UPDATE STATISTICS causes performance degradation
UPDATE STATISTICS causes performance degradation.
Performance is slower after running UPDATE STATISTICS.

Steps to Reproduce

Clarifying Information

Error Message

Defect Number	OE00089706

Enhancement Number

Cause

Resolution

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.

Workaround

Notes

References to Written Documentation:

Progress SQL-92 Guide and Reference

Keyword Phrase

Last Modified Date	9/13/2015 2:23 PM