INNER JOIN ON vs ','+WHERE

From: "Thalis A(dot) Kalfigopoulos" <thalis(at)cs(dot)pitt(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Subject: INNER JOIN ON vs ','+WHERE
Date: 2001-06-25 17:02:12
Message-ID: Pine.LNX.4.21.0106251258410.27771-100000@aluminum.cs.pitt.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 are just thrown in the WHERE clause whereas the former case forces it to follow the user provided join order?

TIA,
thalis

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Frank Hilliard 2001-06-25 17:03:24 Storage limits in PostgreSQL?
Previous Message Bruce Momjian 2001-06-25 16:52:02 Re: Red Hat to support PostgreSQL