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
There are several optimization strategies that you can take advantage ...