MySQL 8 Cookbook

Unused indexes

mysql> SELECT * FROM sys.schema_unused_indexes WHERE object_schema='employees';+---------------+----------------+-------------------+| object_schema | object_name    | index_name        |+---------------+----------------+-------------------+| employees     | departments    | dept_name         || employees     | dept_emp       | dept_no           || employees     | dept_manager   | dept_no           || employees     | employees      | name              || employees     | employees1     | last_name         || employees     | employees1     | full_name         || employees     | employees1     | full_name_desc    || employees     | employees1     | first_name        || employees     | employees1     | full_name_1       || employees     | employees1     | first_name_emp_no || employees     | employees1     | last_name_2       || employees     | employees_mgr  | manager_id        || employees | employees_test | name ...