sql Index

索引的使用情況 (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),幫助你判斷:

  • 哪些索引常被使用
  • 哪些索引根本沒被用到
  • 哪些索引維護成本很高