Inner Join - Explicit vs Implicit Join Performance

Поиск
Список
Период
Сортировка
От Gnanakumar
Тема Inner Join - Explicit vs Implicit Join Performance
Дата
Msg-id 002301cc8e4b$6d147390$473d5ab0$@com
обсуждение исходный текст
Ответы Re: Inner Join - Explicit vs Implicit Join Performance
Список 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 по дате отправления: