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, and how you can improve query performance with basic and advanced index optimizations. Please register here, and no worries if you cannot attend the webinar. We will send you a recording.