Kbase P77965: Complete table scans being performed by MSS DataServer when BY clause is used
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
04/02/2010 |
|
Status: Unverified
SYMPTOM(s):
Complete table scans being performed by the MSS DataServer when BY clause is used
The field used in the BY clause is included in some of existing indexes
SQL Profiler indicates that PROGRESS_RECID index was used in the SQL statement, which is not an effective choice.
FACT(s) (Environment):
Windows
MS SQL DataServer
Progress 9.1D
CAUSE:
Bug# OE00103227
FIX:
The only workaround at the moment is to remove the BY clause from the query. This results in dramatic performance increase.