O'Reilly logo

MySQL 8 Cookbook by Karthik Appigatla

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required