[SQL]查看Table Index的Fragmentation

2012-06-13

6038
0
SQL

我們可透過SSMS來查看某Table中Index的Fragmentation狀況，如下圖!

或是透過T-SQL來查看，如下，


SELECT a.index_id, name, avg_fragmentation_in_percent
FROM sys.dm_db_index_physical_stats (DB_ID(N'你的DBName'), OBJECT_ID(N'你的TableName'), NULL, NULL, NULL) AS a
    JOIN sys.indexes AS b ON a.object_id = b.object_id AND a.index_id = b.index_id;