|The optimiser looks to minimise the number of rows that must be read, so it tries to estimate from each index how many rows must be read. If those estimates are equivalent, it chooses the smaller of the two indexes.
When the query specifies a range of values, the storage engine tries to compute the number of rows in that range. It can do so for single equality conditions and
Last updated 16 Aug 2019