INNER JOIN vs WHERE

From: "T(dot) Alex Beamish" <talexb(at)tabsoft(dot)on(dot)ca>
To: "Postgresql-Performance" <pgsql-performance(at)postgresql(dot)org>
Subject: INNER JOIN vs WHERE
Date: 2003-05-15 01:45:04
Message-ID: 20030515014648.NRXV26559.tomts19-srv.bellnexxia.net@p433
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hello,

I've just had a quick search through the archives but couldn't find
what I wanted, so I've joined this list to continue my search for an
answer.

Is there any rule of thumb about how much more efficient an INNER JOIN
is compare to a regular WHERE statement?

I have a couple of queries in PostgreSQL that use a variety of tables
(four or five) linked together by key/foreign key conditions all ANDed
together. My co-worker re-wrote one of them using the INNER JOIN
approach and I wanted to find out if this would empirically improve the
performance.

I have not tried to do an EXPLAIN ANALYZE yet but I will try that.
Thanks for your responses.

Alex

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Rudi Starcevic 2003-05-15 01:48:20 Re: constraint with reference to the same table
Previous Message Stephan Szabo 2003-05-15 01:24:32 Re: constraint with reference to the same table