On Feb 27, 2004, at 11:26 AM, <mike(at)linkify(dot)com> wrote:
> I'm using postgresl 7.3.2 and have a query that executes very slowly.
> 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.
grzm myrealbox com
In response to
pgsql-general by date
|Next:||From: Alexander Cohen||Date: 2004-02-27 03:08:45|
|Subject: change db encoding|
|Previous:||From: mike||Date: 2004-02-27 02:26:19|
|Subject: correlated delete with "in" and "left outer join"|