mssql 查看索引碎片 并重建索引

SELECT index_type_desc,alloc_unit_type_desc,avg_fragmentation_in_percent,fragment_count,avg_fragment_size_in_pages,
page_count,record_count,avg_page_space_used_in_percent
FROM sys.dm_db_index_physical_stats(DB_ID('数据库'),OBJECT_ID('表名称'),NULL,NULL,'Sampled');

  请尊重知识，请尊重原创 更多资料参考请见  http://www.cezuwang.com/listFilm?page=1&areaId=906&filmTypeId=1

当 字段 avg_fragmentation_in_percent 大于 40% 的时候 就必须考虑整理索引和重建索引的必要性了

ALTER INDEX KID ON BaseCustomer REBUILD