Image

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

Get Effective MySQL Optimizing SQL Statements now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.