4
Creating MySQL Indexes
In this chapter, we will discuss various types of indexes, how MySQL determines indexes, and the impact of adding indexes to your system’s overall performance. We will also be describing how to create indexes for specific given queries. This does not imply that if your environment uses similar tables you should automatically create indexes; these index examples describe how to create and evaluate a particular situation.
Creating indexes is not the only way to optimize an SQL statement. Determining how to optimize the database schema or an application’s use of data from an SQL statement can often have a far greater impact ...
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.
