Chapter 22. Basic Optimizations

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