Kbase P22544: SQL-92 Query performance is slow.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/17/2004 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1D
SYMPTOM(s):
Running query in SQL Explorer runs for several hours.
Query runs for several hours and nothing seems to happen.
Same query run in the Procedure Editor runs very quickly and returns data.
CAUSE:
The optimizer bases query strategies on values it derives from various defaults. These values might not lead to the best performance.
FIX:
Run UPDATE STATISTICS on the tables that are being queried.
The optimizer uses the information from UPDATE STATISTICS to make decisions about the best query strategy to use when executing a particular SQL-92 statement which in turn may improve the query performance significantly.