Simple constricting joins are usually okay, but if you have joins with "or" conditions on largish tables, that can easily throw it off completely. I find that I often need to rewrite those to use union.