Limitations of indexing in MySQL

Source: Internet
Author: User

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.