Bug #81181 Unclear how queries work when a search term exceeds an index prefix
| Submitted: | 22 Apr 2016 16:16 | Modified: | 4 Mar 2019 15:52 |
|---|---|---|---|
| Reporter: | Eric Lewis | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server: Documentation | Severity: | S3 (Non-critical) |
| Version: | 5.7 | OS: | Any |
| Assigned to: | CPU Architecture: | Any |
[22 Apr 2016 16:16]
Eric Lewis
[25 Apr 2016 14:29]
MySQL Verification Team
In principle, it is quite simple. Index will be used for all searches where the constant string is smaller or equal to the index prefix. If this is not well explained , then it should be ......
[4 Mar 2019 15:52]
Daniel Price
Posted by developer: The following section was updated: https://dev.mysql.com/doc/refman/5.5/en/column-indexes.html#column-indexes-prefix "If a search term exceeds the index prefix length, the index is used to exclude non-matching rows, and the remaining rows are examined for possible matches."
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.049 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.