"Thalis A. Kalfigopoulos" <[EMAIL PROTECTED]> writes:
> Changing the type of "join" syntax affects the plan-generation time
> and the execution-time. Would it be logical to EXPLAIN the query once
> using the 'FROM a,b,c WHERE...' syntax and then assuming that it
> returns the optimal execution pla
On Mon, 25 Jun 2001, Tom Lane wrote:
> "Thalis A. Kalfigopoulos" <[EMAIL PROTECTED]> 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 cl
