How can I optimize this query - Mailing list pgsql-sql

From Jainendra Kumar P
Subject How can I optimize this query
Date
Msg-id 284E845CC8F394409203F065D218205C044896@mysmsg03.ad.infosys.com
Whole thread Raw
Responses Re: How can I optimize this query  (Bruno Wolff III <bruno@wolff.to>)
List pgsql-sql
I have the following query

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

How can I optimize this query?

Thanks
Jain



pgsql-sql by date:

Previous
From: Roberto João Lopes Garcia
Date:
Subject: Test, please ignore
Next
From: Kris Jurka
Date:
Subject: Re: MINUS & ROWNUM in PostGres