MySQL 5.0 Certification Study Guide

This chapter discusses general principles that are useful for optimizing queries to run more efficiently. It covers the following exam topics:

• An overview of general optimization principles

• Using indexing and other techniques to optimize query execution

• Choosing storage engines to match application requirements