Link You Today
Bookmark your Free, Libre software & tech link

data base MySQL 8.0 Invisible Indexes

mariadb, mysql, percona

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 …