Re: [SQL] How can I optimize this query

2003-09-09 Thread Bruno Wolff III
On Tue, Sep 09, 2003 at 13:39:10 +0530, Jainendra Kumar P <[EMAIL PROTECTED]> wrote: > I have the following query > > UPDATE accumulator1 SET accumulator1.status = "User Excluded" > WHERE accumulator1.name NOT IN > (SELECT DISTINCT accumulator1.name > FROM accumulator1, diaaffectedstmts > WHER

[SQL] How can I optimize this query

2003-09-09 Thread 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");