Re: Which of the solution is better?

From: Andrew Sullivan <andrew(at)libertyrms(dot)info>
To: PgSQL Performance ML <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Which of the solution is better?
Date: 2002-12-11 15:48:28
Message-ID: 20021211104828.F31768@mail.libertyrms.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Wed, Dec 11, 2002 at 11:26:20AM -0500, Wei Weng wrote:
> I don't think there is any. It is just another way to write an outer
> join.

That's not exactly true. Doing A JOIN B ON (A.ID=B.ID) constrains
the planner. See the section on explicit join order in the
PostgreSQL manual.

The IN locution, by the way, is almost always bad in Postgres. Avoid
it.

A

--
----
Andrew Sullivan 204-4141 Yonge Street
Liberty RMS Toronto, Ontario Canada
<andrew(at)libertyrms(dot)info> M2P 2A8
+1 416 646 3304 x110

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Wei Weng 2002-12-11 16:26:20 Re: Which of the solution is better?
Previous Message Ron Johnson 2002-12-11 05:46:04 Re: Which of the solution is better?