> What is the advantage (or advantages) of using JOIN instead of WHERE in a
> SELECT statement?
> Is JOIN faster than WHERE?
> I have a SELECT statement that involves 7 tables and I am using WHERE to
> relate them and get the result I need but I want to know if there is a
> performance issue if I change to JOIN.
> Jorge Maldonado
When it comes to speed they are both the same (talking about INNER JOIN here).
You can check the query plan and see it's the same for both.
About the advantages of using JOIN. This is my opinion but for many tables
it's easyer to read the query with JOIN then WHERE clause.
A small example:
a.id = b.aid
WHERE a.id = 'value'
FROM a, b
WHERE a.id = b.aid
AND a.id = 'value'
Now with many tables it's a bit easier to see the relations while using JOIN
instead of WHERE and using WHERE only for conditions.
In response to
pgsql-novice by date
|Next:||From: Jasen Betts||Date: 2010-03-05 21:27:02|
|Subject: Re: are primary keys always 'needed'|
|Previous:||From: JORGE MALDONADO||Date: 2010-03-05 18:18:40|
|Subject: WHERE AND JOIN STATEMENTS|