The purpose of this article is to explain (mainly to myself) a technique for creating good indexes for mysql database. Before starting I would like to discuss about selectivity. Index selectivity is the ratio of number of distinct indexed values ( the cardinality) over the total numbers of rows in the table (#T), and ranges […]