Kbase P9571: Drop in SQL query performance when upgrading to 9.1C
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Unverified
FACT(s) (Environment):
Windows
Progress 9.1C
SYMPTOM(s):
Significant drop in performance when executing a SQL query using an SQL92 ODBC connection.
Performance using the same SQL query via an SQL89 ODBC connection to a 9.0B database was significantly better.
CHANGE:
Upgraded to 9.1C and began using SQL92 for ODBC access.
CAUSE:
SQL92 query optimizer didn't select the best index for the query.
FIX:
Modify SQL query to force the SQL92 query optimizer to select another index to enhance the query's performance.