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.
