Oh, I forgot to mention that this has been working fine for about 4 years, then suddenly got really slow... that's why I thougt Rushmore might not be in effect
>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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only