Re: Inner Join - Explicit vs Implicit Join Performance

Hello

no, there is no difference - you can check it via EXPLAIN statement

Regards

Pavel Stehule

2011/10/19 Gnanakumar <gnanam(at)zoniac(dot)com>:
> 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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance
>