Skip site navigation (1) Skip section navigation (2)

Re: slow query - where not in

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Michael Paesold <mpaesold(at)gmx(dot)at>
Cc: Jeremiah Elliott <jelliott(at)artcobell(dot)com>,pgsql-performance(at)postgresql(dot)org
Subject: Re: slow query - where not in
Date: 2003-03-28 17:53:56
Message-ID: 20030328175356.GA12549@wolff.to (view raw or flat)
Thread:
Lists: pgsql-performance
On Fri, Mar 28, 2003 at 17:53:46 +0100,
  Michael Paesold <mpaesold(at)gmx(dot)at> wrote:
> Bruno Wolff III <bruno(at)wolff(dot)to> wrote:
> 
> I think this should rather be:
> 
> SELECT shoporder FROM sodetailtabletrans
>   WHERE NOT EXISTS (
>     SELECT 1 FROM soheadertable
>     WHERE soheadertable.shoporder = sodetailtabletrans.shoporder
>     )

Thanks for catching my mistake.


In response to

Responses

pgsql-performance by date

Next:From: Jeremiah ElliottDate: 2003-03-28 20:58:48
Subject: Re: slow query - where not in
Previous:From: Ulli MuecksteinDate: 2003-03-28 17:04:47
Subject: calling analyze from a stored procedure in C

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group