提高SQL Server性能，可通过DBCC DBREINDEX重建索引 提高SQL Server性能，本文将详细介绍DBCC DBREINDEX重建索引的全过程。,详情请看下载 欢迎大家学习！ use ADVENTUREWORKS_DATA declare @table_id int set @table_id=object_id('[HumanResources].[Employee]') select @table_id as table_id dbcc showcontig(@tabl
use ADVENTUREWORKS_DATA declare @table_id int set @table_id=object_id('[HumanResources].[Employee]') select @table_id as table_id dbcc showcontig(@table_id) dbcc dbreindex('[HumanResources].[Employee]',' ',5) DBCC INDEXDEFRAG('ADVENTUREWORKS_DATA','
