In this case, 12 records should have been deleted. The SELECT was not
much faster.


>Kevin,
>
>How many records are deleted by this statement? How fast is SELECT for the same JOIN?
>
>>
>>I'm having a problem with these 2 commands. The first takes 29 seconds to
>>run against 849,000 records on the local PC, and the second takes 40 seconds.
>>
>>cAlias contains the name of a temp table, created on the fly in the query
>>routine. There is an index on DtId. Since this will be running on network data, and
>>is called when the user clicks Save, they are entirely too slow.
>>
>>I'm tring to remove these records before they are re-saved. Any ideas on how to
>>do this faster?
>>
>>

>>DELETE Commits;
>>  FROM Commits;
>>  JOIN &cAlias ON &cAlias..DtId = Commits.DtId
>>
>>DELETE FROM Commits;
>> WHERE DtId IN;
>> (SELECT DtId FROM &cAlias)
>>

>>