SELECT * FROM `schema_redundant_indexes`
Filtrer les lignes: |
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 | |
---|---|---|---|---|---|---|---|---|---|---|
webtrees | wt_placelinks | wt_placelinks_pl_p_id_index | pl_p_id | 1 | PRIMARY | pl_p_id,pl_gid,pl_file | 0 | 0 | ALTER TABLE `webtrees`.`wt_placelinks` DROP INDEX ... |
Filtrer les lignes: |