Thanks for getting back.
The command is like this.
SCAN FOR transact.idate<=m.updtdate AND ;
transact.itrancode="Q" AND ;
transact.ilookfordd="Y"
...
ENDSCAN
The table has (among others)indexes on idate and itrancode.
I've never heard of set collate before, (There's nothing in my manual)
but set ("collate") yields "machine". I don't know how to find the collate setting of the index. Is this a 2.6 thing?
>Hi Simon,
>
>>I'm having a problem whereby a SCAN is taking a *VERY* long time, and I suspect that this is due to RUSHMORE not being used.
>
>Can you post the FOR condition of the SCAN loop as well as all the indexes set up for the table? Also, make sure that the current SET COLLATE setting matches the collate setting of the index (IDXCOLLATE()).
>
>Christof
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement