10 Tips for Optimizing MySQL Queries (That don’t suck)

When I read the last list of 10 tips for optimizing MySQL queries I wanted to scream. They were really bad. So, I spent an hour or so and wrote up my own list. I think it fares much better. What do you think?