3 ms·
I think it matters specially with big queries. When you have dozens of tables, it really helps to separate the joins from the where clause.
by forinti 2y ago
I think it matters specially with big queries. When you have dozens of tables, it really helps to separate the joins from the where clause.
- chrisandchris 2y agoFor myself, this is even with a couple of tables valid. I think of the query as "looking up references in a book". Therefore I write global filters in the WHERE and stuff specific to a table in the ON condition.