Kbase P97761: Oracle DataServer does not generate the correct index hint when running a query with ORDER BY DESC
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/08/2005 |
|
Status: Unverified
FACT(s) (Environment):
Oracle DataServer
SYMPTOM(s):
Oracle DataServer does not generate the correct index hint when running a query with ORDER BY DESC
The index used by the query is a Descending index
The performance is really slow when running the query
CAUSE:
Bug# 20041028-009
FIX:
This is fixed in 9.1E02.
If applying the Service Pack 9.1E02 is not an option, as a workaround, add QUERY-TUNING(NO-INDEX-HINT) in the query.
For example:
OPEN QUERY q FOR EACH Table WHERE Field1>= DATE("01/01/1950") AND Field2 <= DATE("01/01/2050") NO-LOCK
BY Field1 DESCENDING
BY Field2 DESCENDING
QUERY-TUNING(NO-INDEX-HINT).