Inner Join - Explicit vs Implicit Join Performance

From: "Gnanakumar" <gnanam(at)zoniac(dot)com>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: Inner Join - Explicit vs Implicit Join Performance
Date: 2011-10-19 10:39:44
Message-ID: 002301cc8e4b$6d147390$473d5ab0$@com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi,

In PostgreSQL, is there any performance difference between queries written
using "explicit join notation" vs "implicit join notation" in complex
queries?

EXAMPLE: Simple "explicit join notation"
SELECT *
FROM employee INNER JOIN department
ON employee.DepartmentID = department.DepartmentID;

EXAMPLE: Simple "implicit join notation"
SELECT *
FROM employee, department
WHERE employee.DepartmentID = department.DepartmentID;

Regards,
Gnanam

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Pavel Stehule 2011-10-19 11:14:24 Re: Inner Join - Explicit vs Implicit Join Performance
Previous Message d.davolio@mastertraining.it 2011-10-19 09:46:42 How many Cluster database on a single server