mysql检查索引过多表

select table_schema, table_name,count(0)
from (
SELECT  distinct   table_schema, table_name, index_name  
FROM  information_schema.STATISTICS
) a 
group by   table_schema, table_name
having count(0) > 10
order by  count(0) desc;