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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-performance by date

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