The Difference Between SQL’s JOIN .. ON Clause and the Where Clause
It does not seem matter at all. Both queries yield the same result as well as the same plan. But in fact, in a INNER JOIN they are same, But on OUTTER JOIN
they are different.
Appears in lists (1)
More like this (4)
The Cost of Useless Surrogate Keys in Relationship Tables — A look at the pros and...
How We Built a Cost-Based SQL Optimizer — An under the hood look at CockroachDB's new...
Understanding Deadlocks in MySQL & PostgreSQL There are several types of locks but, the important thing...