Limitations of indexing in MySQL
As you work with indexes, you also understand the limitations of indexes in MySQL so that you can avoid the problems of limitations as much as possible in your index application. The following is a list of the current limitations related to index usage in MySQL.
1) The sum of the index key lengths of the MyISAM storage engine cannot exceed 1000 bytes;
2) Blob and text type columns can only create prefix indexes;
3) MySQL currently does not support function indexing;
4) MSYQL cannot use an index when it is not equal to (! = or <>);
5) After the filter field uses a function operation (such as ABS (column)), MySQL cannot use the index;
6) When the Join condition field type is inconsistent in the join statement, MySQL cannot use the index;
7) When using the like operation, MySQL cannot use the index when the condition starts with a wildcard character (such as '%abc ... ');
8) When using a non-equivalence query, MySQL cannot use the hash index.
When working with indexes, you need to be aware of these limitations, especially if you are not able to use indexes, because this can easily cause great performance pitfalls.
Limitations of indexing in MySQL