MySQL Invisible Indexes: A Reversible Safety Net Before Dropping Indexes
Dropping an index is irreversible. MySQL 8.0 invisible indexes let you hide an index from the optimizer while keeping it maintained, giving you a safe trial period before committing to DROP INDEX.