索引的使用情況 (Index Usage Statistics)
SELECT OBJECT_NAME(i.object_id) AS TableName, i.name, us.user_seeks, us.user_scans, us.user_updates FROM sys.indexes i LEFT JOIN sys.dm_db_index_usage_stats us ON i.object_id = us.object_id AND i.index_id = us.index_id
查看 索引的使用情況 (Index Usage Statistics),幫助你判斷:
- 哪些索引常被使用
- 哪些索引根本沒被用到
- 哪些索引維護成本很高