performance - self-joins vs. subqueries

From: "K(dot) Ari Krupnikov" <ari(at)iln(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: performance - self-joins vs. subqueries
Date: 2001-02-12 15:33:24
Message-ID: 3A880244.4F0C5F5F@iln.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mark 2001-02-12 15:39:24 jdbc fastpath error & Z error (URGENT NEED!!!)
Previous Message Fred Yankowski 2001-02-12 15:23:05 Re: startup Postgres on NT