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  (Pavel Stehule <pavel.stehule@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: "d.davolio@mastertraining.it"
Дата:
Сообщение: How many Cluster database on a single server
Следующее
От: Pavel Stehule
Дата:
Сообщение: Re: Inner Join - Explicit vs Implicit Join Performance