Are there best practices for sticking conditions in WHERE clauses vs the JOIN statement?
Lets say I have two tables, A and B and I need to join a subset of them.
Is there best practices of sticking the conditions in the WHERE clause like this,
SELECT * FROM A JOIN B on a.fk_b = b.pk WHERE a.pk <10000
versus sticking the condition in the JOIN like this,
SELECT * FROM A JOIN B on a.fk_b = b.pk AND a.pk <10000
For these, it doesn't make any difference in speed or results, but are there best practices for where to put the conditions?