SqlServer快速重建索引

USE [数据库名称]

DECLARE @name varchar(100)
 
DECLARE authors_cursor CURSOR FOR  
Select [name]   from sysobjects where xtype='u' order by id
 
OPEN authors_cursor -- 开启游标执行任务
 
FETCH NEXT FROM authors_cursor  INTO @name  --将游标向下移1行，获取的数据放入之前定义的变量@name
 
WHILE @@FETCH_STATUS = 0  -- 正常读取
BEGIN    
   DBCC DBREINDEX (@name, '', 90)
   FETCH NEXT FROM authors_cursor  
   INTO @name 
END
 
deallocate authors_cursor  --释放游标