Inner Join - Explicit vs Implicit Join Performance - Mailing list pgsql-performance

From Gnanakumar
Subject Inner Join - Explicit vs Implicit Join Performance
Date
Msg-id 002301cc8e4b$6d147390$473d5ab0$@com
Whole thread Raw
Responses Re: Inner Join - Explicit vs Implicit Join Performance  (Pavel Stehule <pavel.stehule@gmail.com>)
List 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



pgsql-performance by date:

Previous
From: "d.davolio@mastertraining.it"
Date:
Subject: How many Cluster database on a single server
Next
From: Pavel Stehule
Date:
Subject: Re: Inner Join - Explicit vs Implicit Join Performance