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.

View original article

Pin It on Pinterest

Share This