covering-index

A covering index is not the same as a composite index. If I have 2 separate indexes one on col3 and the other on col4, Which one of them will be used in this query ? The index with the highest cardinality. MySQL keeps statistics on which index has what properties. The index that has … Read more