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. ...