查找冗余或重复的索引

select a.table_schema as '数据名'
,a.table_name as '表名'
,a.index_name as '索引1'
,b.index_name as '索引2'
,a.column_name as '重复列名'
from statistics a join statistics b on
a.table_schema=b.table_schema and a.table_name=b.table_name
and a.seq_in_index=b.seq_in_index and a.column_name=b.column_name
where a.seq_in_index =1 and a.index_name<>b.index_name;