See Section 5. 5, “Server System Variables”. You can use SET max_seeks_for_key=value as an alternative way to force MySQL to prefer key scans instead of table scans.
For additional documentation on MySQL products, including translations of the documentation into other languages, and downloadable versions in variety of formats, including HTML and PDF formats, see the MySQL Documentation Library.
This product may include third-party software, used under license. 7, see this document for licensing information, including licensing information relating to third-party software that may be included in this Commercial release. If you are using a Community release of MySQL 5. If you are using a Commercial release of MySQL 5. 7, see this document for licensing information, including licensing information relating to third-party software that may be included in this Community release.
This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognising you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.
Strictly Necessary Cookies
Strictly Necessary Cookie should be enabled at all times so that we can save your preferences for cookie settings.
If you disable this cookie, we will not be able to save your preferences. This means that every time you visit this website you will need to enable or disable cookies again.
See Section 5. 5, “Server System Variables”. You can use SET max_seeks_for_key=value as an alternative way to force MySQL to prefer key scans instead of table scans.
For additional documentation on MySQL products, including translations of the documentation into other languages, and downloadable versions in variety of formats, including HTML and PDF formats, see the MySQL Documentation Library.
This product may include third-party software, used under license. 7, see this document for licensing information, including licensing information relating to third-party software that may be included in this Commercial release. If you are using a Community release of MySQL 5. If you are using a Commercial release of MySQL 5. 7, see this document for licensing information, including licensing information relating to third-party software that may be included in this Community release.