Session: MySQL Indexes, Histograms, And Other Ways to Speed Up Your Queries
You add an index to your database to try and speed things up and it sort of helps. You add another index and performance dives! What happened? Speeding up a query is not a secret or magic but engineering. In this extended session you will learn what indexes really are, when they help, the various types of indexes, and how to read a Query Plan to understand how they are being used. Plus you will see how histograms can be used, why they do not suffer the same overhead penalty that an index has, and when to best use them. And you will see how new locking options, optimizer hints, and some other simple to implement options can really speed up your queries.
