[MySQL]: optimizer Index strategy

If the table has a multiple-column index, any leftmost prefix of the index can be used by the optimizer to find rows.  For example, if you have a three-column index on (col1, col2, col3), you have indexed search capabilities on…