Re: INNER JOIN ON vs ','+WHERE

"Thalis A. Kalfigopoulos" <thalis@cs.pitt.edu> writes:
> I noticed that doing a join with the INNER JOIN ON... syntax gives a different execution plan (for complex queries at
least)than when using the ',' syntax with the join conditions in the WHERE clause. Actually the latter proved more
efficient:-/ 
> I assume/guess/speculate that the optimizer gets more freedom in the order it'll perform the join when all conditions
arejust thrown in the WHERE clause whereas the former case forces it to follow the user provided join order? 

http://www.ca.postgresql.org/users-lounge/docs/7.1/postgres/explicit-joins.html

            regards, tom lane