MySQL 8.0 Invisible Indexes.md 504 B
Title: "MySQL 8.0 Invisible Indexes" Date: 2017-01-15 16:13:12 Categories: [data base] tags: [mysql, mariadb, percona]
Authors: sedlav
MySQL 8.0 has a new feature called “invisible indexes,” which allow you to quickly enable/disable indexes from being used by the MySQL Optimizer... There are a couple of use cases. One of them is if you want to drop an index, but want to know the effect beforehand ...