摘要:
1. 统计没用使用过的索引:如果有聚集索引,则表为B-Tree如果没有聚集索引,则表为Heapselect b.name ,a.name ,a.index_id,c.object_id from sys.indexes ainner join sys.tables bon a.object_id=b.object_id and a.name is not null left join sys.dm_db_index_usage_stats con a.object_id=c.object_id and c.database_id=db_id()and c.index_id<>0 - 阅读全文