SELECT * FROM `schema_redundant_indexes`
|
table_schema | table_name | redundant_index_name | redundant_index_columns | redundant_index_non_unique | dominant_index_name | dominant_index_columns | dominant_index_non_unique | subpart_exists | sql_drop_index | |
---|---|---|---|---|---|---|---|---|---|---|
agroculture | buyer | bid | bid | 0 | PRIMARY | bid | 0 | 0 | ALTER TABLE `agroculture`.`buyer` DROP INDEX `bid` | |
agroculture | farmer | fid | fid | 0 | PRIMARY | fid | 0 | 0 | ALTER TABLE `agroculture`.`farmer` DROP INDEX `fid... | |
college | Biblioteki | kod_biblioteki | kod_biblioteki | 0 | PRIMARY | kod_biblioteki | 0 | 0 | ALTER TABLE `college`.`Biblioteki` DROP INDEX `kod... | |
college | Chitalnye_zaly | kod_zala | kod_zala | 0 | PRIMARY | kod_zala | 0 | 0 | ALTER TABLE `college`.`Chitalnye_zaly` DROP INDEX ... | |
college | Chitateli | kod_chitatelya | kod_chitatelya | 0 | PRIMARY | kod_chitatelya | 0 | 0 | ALTER TABLE `college`.`Chitateli` DROP INDEX `kod_... | |
college | Literatura | kod_literatury | kod_literatury | 0 | PRIMARY | kod_literatury | 0 | 0 | ALTER TABLE `college`.`Literatura` DROP INDEX `kod... | |
college | Vidacha_literatury | kod_vidachi | kod_vidachi | 0 | PRIMARY | kod_vidachi | 0 | 0 | ALTER TABLE `college`.`Vidacha_literatury` DROP IN... |
|