Effective MySQL Optimizing SQL Statements

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