SELECT * FROM `schema_unused_indexes`
|
object_schema | object_name | index_name | |
---|---|---|---|
performance_schema | file_summary_by_instance | EVENT_NAME | |
performance_schema | file_summary_by_instance | FILE_NAME | |
performance_schema | threads | THREAD_OS_ID | |
performance_schema | threads | RESOURCE_GROUP | |
performance_schema | threads | PROCESSLIST_ACCOUNT | |
performance_schema | threads | PROCESSLIST_ID | |
performance_schema | threads | NAME | |
performance_schema | threads | PROCESSLIST_HOST | |
sakila | address | idx_fk_city_id | |
sakila | customer | idx_fk_address_id | |
sakila | customer | idx_last_name | |
sakila | film | idx_fk_original_language_id | |
sakila | film | idx_title | |
sakila | film_actor | idx_fk_film_id | |
sakila | film_category | fk_film_category_category | |
sakila | film_text | idx_title_description | |
sakila | inventory | idx_store_id_film_id | |
sakila | payment | idx_fk_customer_id | |
sakila | payment | fk_payment_rental | |
sakila | payment | idx_fk_staff_id | |
sakila | rental | idx_fk_inventory_id | |
sakila | rental | idx_fk_customer_id | |
sakila | rental | idx_fk_staff_id | |
sakila | staff | idx_fk_address_id | |
sakila | store | idx_fk_address_id |
|