Many of our users, developers and database administrators, keep
asking our team about EverSQL’s indexing recommendations
So, we decided to write about it.
This tutorial won’t detail all the internals of the algorithm,
but rather try to lay down the basic and important aspects of
indexing, in simple terms.
Also, and most importantly, we’ll present practical examples for
properly indexing your tables and queries by relying on a set of
rules, rather than on guessing.
Our focus in this tutorial is on MySQL, MariaDB and PerconaDB
databases. This information may be relevant for other database
vendors as well, but in some cases may not.
Which indexes should I create for an SQL query?
As a general rule of thumb, MySQL can only use on index for each
table in the query. Therefore, there is no point in creating more
than one index for each query. Preferably, same indexes should
match as …[Read more]