The join optimizer calculates the order in which tables should be joined. The table read order forced by
LEFT JOIN or STRAIGHT_JOIN helps the join optimizer do its work much more quickly, because there are fewer table permutations to check.http://dev.mysql.com/doc/refman/5.0/en/left-join-optimization.html
