>>Bruce,
>>
>>>I have some very large tables from which I have to get records NOT IN other very large tables. Code like this:
>>
>>>select * from table1;
>>>where keyfield NOT IN;
>>>(select keyfield from table2)
>>
>>how about
>>
>>USE TABLE1
>>USE TABLE2 ORDER TAG keyfieldTag
>>
>>SET RELATION TO Keyfield INTO Table2
>>
>>BROWSE NORMAL FOR EOF("Table2")
>>
>>You might want to copy this into a temp table
>>
>>COPY TO Temptable *FOR* EOF("Table2")
>
>Well, it was very fast until the COPY TO. Then it got almost completely stuck on COPY TO :(
It could be completely stupid, but what if you add SET OPTIMIZE OFF right before COPY TO ?
Edward Pikman
Independent Consultant