How Indexes Work in MySQL

How Indexes Work in MySQ

Finely tune your query writing and database performance with tips from the experts.

MySQL offers a few different types of indexes and uses them in a variety of ways. There’s a lot to know about the various kinds of indexes and how they interact with the storage engines, and it’s all very important for query optimization. A few examples are listed below:

  • The “leftmost prefix rule”
  • Clustered primary indexes versus secondary indexes
  • B-Tree and hash
  • New types of indexes such as LSM and Fractal Trees
  • Newer features in the query optimizer and executor in MySQL 5.6 and 5.7

You will leave this webinar with a better understanding of how MySQL and its storage engines use indexes to speed up queries, as well as how you can improve query performance with basic and advanced index optimizations. Register below, and we will send you a copy of the recording and slide deck.