1. If multiple columns are indexed, follow the leftmost prefix rule, which refers to the query starting at the leftmost top of the index and not skipping the columns in the index.
2. Do not do any operations on the index (compute, function, (automatic or manual) type conversion), will cause index loss and turn to full table scan.
3. The storage engine cannot use the columns to the right of the range criteria in the index. (the column index after the range condition is missing)
4. Try to use an overlay index (the index-only query (indexed columns and query columns are consistent)), reducing the SELECT *
5. The inability to use the index when MySQL is not equal to (! = or <>) can result in a full table scan.
6 null,isnull also cannot use the index.
7. Like starts with a wildcard ('%0ABC '), the MySQL index fails to become a full table scan
8. String does not add single quote index invalidation
9. Do not use or, the index will fail when connected with it.
Note: You must use the form like '%abc% ' to ensure that the index does not expire? Use the overwrite index.
MySQL's index optimizer