[SQL] How can I optimize this query

[Jainendra Kumar P]

I have the following query

UPDATE accumulator1 SET accumulator1.status = "User Excluded"
WHERE accumulator1.name NOT IN
(SELECT DISTINCT accumulator1.name
 FROM accumulator1, diaaffectedstmts
 WHERE diaaffectedstmts.stmt like '*'+ accumulator1.name +'*' and
diaaffectedstmts.xref_type <>  
 "D");

How can I optimize this query?

Thanks
Jain


---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend