SQL Server 索引重建或索引重組
摘要:
查询索引的碎裂状态T-SQL语法(适用于SQL Server 2005以上):SELECT OBJECT_NAME(dt.object_id) , si.name , dt.avg_fragmentation_in_percent, dt.avg_page_space_used_in_percentFROM (SELECT object_id , index_id , avg_fragmentation_in_percent, avg_page_space_used_in_percent FROM sys.dm_db_index_physical_stats (DB_ID(), NULL, N 阅读全文
posted @ 2011-08-05 09:13 中国蓝天 阅读(1034) 评论(0) 推荐(1) 编辑