Hello no, there is no difference - you can check it via EXPLAIN statement Regards Pavel Stehule 2011/10/19 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 > -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
