Message-ID: <39F86FFA.A1499290@agliodbs.com>
Date: Thu, 26 Oct 2000 10:55:06 -0700
From: Josh Berkus <josh@agliodbs.com>
Reply-To: josh@agliodbs.com
Organization: Aglio Database Solutions
MIME-Version: 1.0
To: sqllist <pgsql-sql@postgresql.org>
Subject: Re: Query Problem
References: 
 <7F124BC48D56D411812500D0B74725140614B4@fileserver002.intecsystems.co.uk>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Michael,

> SELECT Data
> FROM Table A
> WHERE NOT EXISTS (
>     SELECT * FROM Table_B, Table_C
>     WHERE Table_B.GroupID = TableC.GroupID
>     AND TableC.AccountID = 11
> )
> 
> I think that the not exists is a bit quicker than the NOT IN.  Give it
> a whirl.

A *lot* faster.  Like, 7x as fast. I'd forgotten about EXISTS, since I
so seldom have a use for it ... but this is shy it was created, I guess.

Thanks so much for your help!

					-Josh Berkus
-- 
______AGLIO DATABASE SOLUTIONS___________________________
                                        Josh Berkus
   Complete information technology      josh@agliodbs.com
    and data management solutions       (415) 436-9166
   for law firms, small businesses       fax  436-0137
    and non-profit organizations.       pager 338-4078
                        		San Francisco