>>>>Perhaps with the selfsame command, but adding an index on the key expression - an index on
dtos(dTraBan) + cRefBan..., especially in the historical file.
>>>
>>>Thanks Hilmar. Tried and didn't seem to help much.
>>>
>>>Alex
>>
>>Other options include an outer join, and doing a SET RELATION to the history table (copy those that have something like
eof("HistoryTable")). I am not sure whether any of these options would be faster.
>
>Hilmar and Naomi,
>
>I am going to add a column with a hash of the others and compare the hashes. Looking for hash function...
>
>Alex
May be you can use CHECKSUM() function? Have you tried my other suggestion, BTW?
If it's not broken, fix it until it is.
My Blog