Kbase P49908: Displaying records in descending order take longer than ascending order.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/07/2005 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1D
SYMPTOM(s):
Displaying records in descending order take longer than ascending order.
Using ADM Smart Objects executing a query with descending takes longer than executing the query with ascending.
Implemented INDEXED-REPOSITION for performance
CAUSE:
Descending order is a sort operation. INDEXED-REPOSITION is ignored and does not optimize the query in cases of either a Progress database not being used or sorting and preselection is being performed.
FIX:
Create a new index that defines the order as descending and use this index for your object.