Inner Join - Explicit vs Implicit Join Performance

["Gnanakumar" <gnanam@xxxxxxxxxx>]

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



-- 
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance