Image

3

Understanding MySQL Indexes

Creating the right indexes is one of the most significant techniques for SQL performance tuning. Before creating MySQL indexes, as discussed in the following chapter, you need to understand the MySQL architectural details about how indexes are organized on disk, how indexes and memory usage operate, and how the differences between storage engines affect index selection. This understanding is a necessary prerequisite to mastering optimal index creation in a MySQL production environment. You might find this chapter less interesting; however, the specific nature of indexes and a detailed knowledge of how MySQL operates ...

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

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.