查找索引碎片和重建索引

SELECT a.index_id,name,avg_fragmentation_in_percent
FROM sys.dm_db_index_physical_stats (DB_ID(N'iWOMTrackData'), OBJECT_ID(N'HumanResources.Employee'), NULL, NULL, NULL) AS a
    JOIN sys.indexes AS b ON a.object_id = b.object_id AND a.index_id = b.index_id order by avg_fragmentation_in_percent desc; 
GO
ALTER INDEX IX_Item_Title_BID_State_Item_ID ON SEC_Item REBUILD;
go