DELETE EXISTS Query Freezes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have been working on the Delete Query all day. Does anyone see why it
would freeze.

DELETE [A].*
FROM Router_Update AS A
WHERE EXISTS (SELECT .*
FROM Lowest_Date_Duplicates_Router_Update AS B
WHERE (([A].[VORNR] = .[VORNR]) AND ([A].[AEDAT3] = .[AEDAT3]) AND
([A].[MATNR] = .[MATNR]) AND ([A].[MAKTX] = .[MAKTX]) AND ([A].[WERKS]
= .[WERKS]) AND ([A].[ARBID] = .[ARBID]) AND ([A].[KTSCH] =
.[KTSCH]) AND ([A].[ARBPL] = .[ARBPL])));

Thanks
 
Try rewritting this using an inner join

DELETE DISTINCTROW A.*
FROM Router_Update AS A INNER JOIN
Lowest_Date_Duplicates_Router_Update AS B
ON ([A].[VORNR] = .[VORNR])
AND ([A].[AEDAT3] = .[AEDAT3])
AND ([A].[MATNR] = .[MATNR])
AND ([A].[MAKTX] = .[MAKTX])
AND ([A].[WERKS] = .[WERKS])
AND ([A].[ARBID] = .[ARBID])
AND ([A].[KTSCH] = .[KTSCH])
AND ([A].[ARBPL] = .[ARBPL])

That should be a lot faster.
 
Thanks Alot Works Great.

Carter

John Spencer said:
Try rewritting this using an inner join

DELETE DISTINCTROW A.*
FROM Router_Update AS A INNER JOIN
Lowest_Date_Duplicates_Router_Update AS B
ON ([A].[VORNR] = .[VORNR])
AND ([A].[AEDAT3] = .[AEDAT3])
AND ([A].[MATNR] = .[MATNR])
AND ([A].[MAKTX] = .[MAKTX])
AND ([A].[WERKS] = .[WERKS])
AND ([A].[ARBID] = .[ARBID])
AND ([A].[KTSCH] = .[KTSCH])
AND ([A].[ARBPL] = .[ARBPL])

That should be a lot faster.

Carter said:
I have been working on the Delete Query all day. Does anyone see why it
would freeze.

DELETE [A].*
FROM Router_Update AS A
WHERE EXISTS (SELECT .*
FROM Lowest_Date_Duplicates_Router_Update AS B
WHERE (([A].[VORNR] = .[VORNR]) AND ([A].[AEDAT3] = .[AEDAT3]) AND
([A].[MATNR] = .[MATNR]) AND ([A].[MAKTX] = .[MAKTX]) AND
([A].[WERKS]
= .[WERKS]) AND ([A].[ARBID] = .[ARBID]) AND ([A].[KTSCH] =
.[KTSCH]) AND ([A].[ARBPL] = .[ARBPL])));

Thanks
Click to expand...
Click to expand...
 
Back
Top