Kbase P120733: SQL-92: Query resolution is not using the indexes expected by the developer.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
1/3/2011 |
|
Status: Verified
SYMPTOM(s):
SQL-92: Query resolution is not using the indexes expected by the developer.
4GL query against database tables uses different indexes from an equivalent SQL query against views on those same tables.
FACT(s) (Environment):
Progress 9.1E
Progress 9.1E02
Progress 9.1E04
All Supported Operating Systems
CAUSE:
The UPDATE STATISTICS statements were never executed against the database or tables involved.
FIX:
Run UPDATE STATISTICS against the database and/or tables referenced by the query.