Postgres Pro
Downloads
Home   >   mailing lists

INNER JOIN ON vs ','+WHERE - Mailing list pgsql-general

From Thalis A. Kalfigopoulos
Subject INNER JOIN ON vs ','+WHERE
Date
Msg-id Pine.LNX.4.21.0106251258410.27771-100000@aluminum.cs.pitt.edu
Whole thread Raw
Responses Re: INNER JOIN ON vs ','+WHERE  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
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? 

TIA,
thalis

pgsql-general by date:

Previous
From: Frank Hilliard
Date:
Subject: Storage limits in PostgreSQL?
Next
From: Vince Vielhaber
Date:
Subject: Re: More Red Hat information