From: Markus Bertheau <twanger@bluetwanger.de>
To: pgsql-sql <pgsql-sql@postgresql.org>
Subject: Difference between IN and JOIN
Date: Mon, 04 Oct 2004 10:39:50 +0200
Message-ID: <1096879190.2651.8.camel@dicaprio.akademie1.de> (raw)
Hi,
I lately wondered if there is a difference between a JOIN and a IN in
queries similar to the following:
SELECT f1 FROM t1 JOIN t2 ON (t.f2 = t2.f2) WHERE t2.f3 = x
SELECT f1 FROM t1 WHERE t1.f2 IN (SELECT f2 FROM t2 WHERE f3 = x)
As I see it there's no semantic difference between the two. Are there
differences in performance or anything else that matters? The execution
plans seem to match except for the use of an "Hash IN Join" in place of
a "Hash Join". Estimated costs match.
Thanks for your advice
--
Markus Bertheau <twanger@bluetwanger.de>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: twanger@bluetwanger.de
Subject: Re: Difference between IN and JOIN
In-Reply-To: <1096879190.2651.8.camel@dicaprio.akademie1.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox