Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group