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 fast.
>
>I'm tring to remove thse records before they are re-saved. Any ideas on hwo 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)
>

>