WHERE AND JOIN STATEMENTS

From: JORGE MALDONADO <jorgemal1960(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: WHERE AND JOIN STATEMENTS
Date: 2010-03-05 18:18:40
Message-ID: f03943a01003051018hceb485fm9cde3cc63f248f52@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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.

Respectfully,
Jorge Maldonado

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Jure Kobal 2010-03-05 19:01:48 Re: WHERE AND JOIN STATEMENTS
Previous Message venkatrao.b 2010-03-05 12:19:38 Re: [NOVICE] Is there any oracle user_source table equivalent in postgre?