Effective MySQL Optimizing SQL Statements

5

Creating Better MySQL Indexes

Creating appropriate indexes is an important optimization technique. In Chapter 4 we discussed the basics of creating MySQL indexes to improve performance for various types of queries. Creating multi column indexes can provide a significant improvement over a single column index. Two more indexing techniques can further improve query performance.

In this chapter we will be covering these additional indexing techniques:

• Creating a covering index

• Creating a partial column index

We will be using the table and data examples as provided in Chapter 4. It is recommended that the example tables and data are repopulated. ...