MySQL 8 Cookbook

Redundant indexes

mysql> SELECT * FROM sys.schema_redundant_indexes WHERE table_name='employees'\G*************************** 1. row ***************************              table_schema: employees                table_name: employees      redundant_index_name: first_name   redundant_index_columns: first_nameredundant_index_non_unique: 1       dominant_index_name: first_name_emp_no    dominant_index_columns: first_name,emp_no dominant_index_non_unique: 1            subpart_exists: 0            sql_drop_index: ALTER TABLE `employees`.`employees` DROP INDEX `first_name`~*************************** 8. row ***************************              table_schema: employees                table_name: employees      redundant_index_name: last_name_2   redundant_index_columns: last_nameredundant_index_non_unique: 1       dominant_index_name: last_name