X-Original-To: pgsql-performance@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 02A99475E77 for ; Fri, 28 Mar 2003 12:54:17 -0500 (EST) Received: from wolff.to (wolff.to [66.93.249.74]) by postgresql.org (Postfix) with SMTP id 28FA347580B for ; Fri, 28 Mar 2003 12:54:16 -0500 (EST) Received: (qmail 12758 invoked by uid 500); 28 Mar 2003 17:53:56 -0000 Date: Fri, 28 Mar 2003 11:53:56 -0600 From: Bruno Wolff III To: Michael Paesold Cc: Jeremiah Elliott , pgsql-performance@postgresql.org Subject: Re: slow query - where not in Message-ID: <20030328175356.GA12549@wolff.to> Mail-Followup-To: Michael Paesold , Jeremiah Elliott , pgsql-performance@postgresql.org References: <200303280938.50382.jelliott@artcobell.com> <20030328155933.GA10761@wolff.to> <028e01c2f54a$9af3d010$3201a8c0@beeblebrox> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <028e01c2f54a$9af3d010$3201a8c0@beeblebrox> User-Agent: Mutt/1.3.25i X-Spam-Status: No, hits=-38.0 required=5.0 tests=BAYES_10,EMAIL_ATTRIBUTION,IN_REP_TO,QUOTED_EMAIL_TEXT, REFERENCES,REPLY_WITH_QUOTES,USER_AGENT_MUTT autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200303/186 X-Sequence-Number: 1484 On Fri, Mar 28, 2003 at 17:53:46 +0100, Michael Paesold wrote: > Bruno Wolff III 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.