What SYS(3054,11) reports on the select? How many records are in cAlias?

>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)
>>>

>>>