Blog Title

After seeing the discussions in http://groups.google.com/group/oursql-conference i thought about the idea of combining a user conference with a music festival.

Optimizing table join order

Something i should have known (and didn't):

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