Do you ever leave your and/or clauses directly in the join?
Lately I have been trying to keep my code cleaner and tightening things up a bit more. Instead of creating huge where clauses I have been putting my and / or operands directly in the join, (if the clause is associated with the join. For instance a address join, I will do and / or = '67%" for an address or for example, instead of where and then your criteria. I find my queries run faster as well, since most of mine are 4 joins at least and some go to attribute tables and can be over 25 joins. Do you practice this as well? Just wondering.