查找未被使用过的索引-20201020
以下附带完整sql
select object_schema,object_name,index_name,b.table_rows from performance_schema.table_io_waits_summary_by_index_usage a join information_schema.tables b
on a.object_schema=b.table_schema and a.object_name=b.table_name
where index_name is not null and count_star=0 order by object_schema,object_name;
创建时间：2021-12-22 09:21
넶浏览量：0
