Postgres Pro
Downloads
Home   >   mailing lists

performance - self-joins vs. subqueries - Mailing list pgsql-general

From K. Ari Krupnikov
Subject performance - self-joins vs. subqueries
Date
Msg-id 3A880244.4F0C5F5F@iln.net
Whole thread Raw
Responses Re: performance - self-joins vs. subqueries
List pgsql-general
Tree view 
Many queries can be formulated as either a self-join or a subquery on
the same table.

Is there any difference in performance, or does the analyzer treat them
the same?


--
K. Ari Krupnikov

DBDOM - bridging XML and relational databases
http://www.iter.co.il

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Howto install postgresql 7.03 on Darwin 1.2
Next
From: adb
Date:
Subject: Re: Re: PostgreSQL vs Oracle vs DB2 vs MySQL - Which should I use?