27,579
社区成员
发帖
与我相关
我的任务
分享
SELECT a.index_id, name, avg_fragmentation_in_percent
FROM sys.dm_db_index_physical_stats (DB_ID(N'数据库名称'), OBJECT_ID(N'dbo.表名'), NULL, NULL, NULL) AS a
JOIN sys.indexes AS b ON a.object_id = b.object_id AND a.index_id = b.index_id;
GO
--如果碎片超过30%,可以考虑重新组织索引
ALTER INDEX 索引名称 ON dbo.表名
REORGANIZE ;
update statistics 表名