Question

如何重建SQL索引 要具体的命令

Answer 1

USE TableName
DECLARE @TableName varchar(255)
DECLARE TableCursor CURSOR FOR
SELECT table_name FROM information_schema.tables
WHERE table_type = 'base table'
OPEN TableCursor
FETCH NEXT FROM TableCursor INTO @TableName
WHILE @@FETCH_STATUS = 0
BEGIN
DBCC DBREINDEX(@TableName,' ',90)
FETCH NEXT FROM TableCursor INTO @TableName
END
CLOSE TableCursor
DEALLOCATE TableCursor

Answer 2

DBCC DBREINDEX (TableName1,Index_Name1)
DBCC DBREINDEX (TableName1,Index_Name2)
DBCC INDEXDEFRAG (TableName2,Index_Name3)
DBCC INDEXDEFRAG (TableName2,Index_Name4)

UPDATE STATISTICS TableName1
UPDATE STATISTICS TableName2

Answer 3

create index index_name
on
table_name | view_name(colume_name[1,,,n])
index_name 是索引名称
table_name|view_name 是表的名称或视图名称
colume_name是表或视图的哪些列上建索引

Answer 4

1：你可以创建一个表，存储重建的表名和索引键
2：创建存储过程 循环重建表的索引，

DBCC INDEXDEFRAG (数据库名,' 表名','索引键 )