Re: correlated delete with "in" and "left outer join"

On Feb 27, 2004, at 11:26 AM, <mike@linkify.com> wrote:

> I'm using postgresl 7.3.2 and have a query that executes very slowly.

<snip />

> I understand that using "in" is not very efficient.
>
> Is there some other way to write this query without the "in"?

NOT EXISTS ( ) is sometimes more efficient. If at all possible, upgrade
to 7.4.1. One of the many things that have improved since 7.3.2 is the
efficiency of queries using IN.

Michael Glaesemann
grzm myrealbox com