NOT EXISTS very slow

[vsaravan]

Please guide me how to improve this query

DELETE
FROM AdjGrp_sum AS adj
WHERE nz(Diff_Amt_USD) = 0 AND nz(Opics_Pnl_Sum) = 0 AND nz(Official_Pnl) = 0 AND nz(Mxg_Sum_AdjGrp) = 0
AND NOT EXISTS (
SELECT 1
FROM AdjGrp_sum AS adj2
WHERE adj.COB = adj2.COB
AND adj.Portfolio = adj2.Portfolio
AND adj.CCY = adj2.CCY
AND adj.System = adj2.System
AND (adj2.Diff_Amt_USD <> 0
OR adj2.Opics_Pnl_Sum <> 0
OR adj2.Official_Pnl <> 0
OR adj2.Mxg_Sum_AdjGrp <> 0
)
)

[Scott Price]

DELETE
FROM AdjGrp_sum AS adj
WHERE nz(Diff_Amt_USD) = 0 AND nz(Opics_Pnl_Sum) = 0 AND nz(Official_Pnl) = 0 AND nz(Mxg_Sum_AdjGrp) = 0
AND NOT EXISTS (
SELECT 1
FROM AdjGrp_sum AS adj2
WHERE adj.COB = adj2.COB
AND adj.Portfolio = adj2.Portfolio
AND adj.CCY = adj2.CCY
AND adj.System = adj2.System
AND (adj2.Diff_Amt_USD <> 0
OR adj2.Opics_Pnl_Sum <> 0
OR adj2.Official_Pnl <> 0
OR adj2.Mxg_Sum_AdjGrp <> 0))

What version of Access are you working with? Could you explain your problem a little more clearly? I'm not sure exactly what the issue is you are asking about here.

Regards,
Scott