MySQL 8.0: Invisible Indexes

MySQL 8.0: Invisible Indexes

Invisible indexes are a new feature in MySQL 8.0 that provide the ability to mark an index as unavailable for use by the Optimizer. This means that the index will still be maintained and kept up-to-date as data is modified, but no queries will be permitted to make use of the index (even if the query uses FORCE INDEX index_name).…

Source: MySQL 8.0: Invisible Indexes

About KENNETH 12541 Articles

Be the first to comment

Leave a Reply

Your email address will not be published.


This site uses Akismet to reduce spam. Learn how your comment data is processed.