X-Original-To: pgsql-sql@postgresql.org
Received: from web12703.mail.yahoo.com (web12703.mail.yahoo.com
	[216.136.173.240])
	by postgresql.org (Postfix) with SMTP id 41C0F475A45
	for <pgsql-sql@postgresql.org>; Tue, 18 Mar 2003 11:54:22 -0500 (EST)
Message-ID: <20030318165427.52097.qmail@web12703.mail.yahoo.com>
Received: from [63.230.97.206] by web12703.mail.yahoo.com via HTTP;
	Tue, 18 Mar 2003 08:54:27 PST
Date: Tue, 18 Mar 2003 08:54:27 -0800 (PST)
From: chester c young <chestercyoung@yahoo.com>
Subject: outer join versus not exists
To: pgsql-sql@postgresql.org
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
X-Archive-Number: 200303/438
X-Sequence-Number: 12477

In pg, is there any performance gain in using outer join with null as
versus using not exists, eg:

select t1.* from t1 right join t2 using( id ) where t2.id is null;

versus

select * from t1 where not exists (select 1 from t2 where t1.id=t2.id);

__________________________________________________
Do you Yahoo!?
Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
http://platinum.yahoo.com