Re: Performance impact of filtering in ON vs WHERE clause

[Apachez]

The USING was just an example which shows you how joins are being handled by the server. Any filtering should be done in the WHERE part, the join statement only tells the server which columns relate to each other.

However the optimizer will most likely try to fix you badly written "filter inside join statement" so it will be a proper "join statement" along with a "filtering in the WHERE part".

An EXPLAIN SELECT should show you what happends...