Kbase P13151: Slow performance when using SQL-92
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/17/2004 |
|
Status: Verified
FACT(s) (Environment):
Progress 9.1D
SYMPTOM(s):
Slow performance with SQL-92 ODBC driver
UPDATE STATISTICS has not been run so current table statistics are not available to improve performance
CAUSE:
The fields being references in the WHERE clause do not have any indexes defined for them so Progress has to do a full table scan
FIX:
Define indexes and run UPDATE STATISTICS on queried tables to improve performance