Kbase P13256: UPDATE INDEX STATISTICS causes performance degredation
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
27/09/2007 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1D
SYMPTOM(s):
UPDATE INDEX STATISTICS causes performance degradation
SQL query runs much slower after UPDATE INDEX STATISTICS
CAUSE:
Bug #20021021-025
FIX:
Do not use UPDATE INDEX STATISTICS. UPDATE STATISTICS can be used to increase performance. If UPDATE INDEX STATISTICS has been used, delete the contents of the sysprogress.sysidxstat table and run UPDATE STATISTICS only.
i.e.:
delete from sysprogress.sysidxstat;
commit;
Performance can also be increased for some SQL queries after using UPDATE STATISTICS by using the {NO REORDER} clause in the FROM phrase of the query in SQL Explorer.
i.e:
select *
from table {NO REORDER}
where x = 1;