This chapter describes several join optimizations. Note that not all optimizations are described. Use an EXPLAIN to see a summary of the optimizations done for your queries.
More information about how to optimize the performance of your database from other perspectives can be found in Database Design.