Tagged: SQL Index

Bygga om index i en SQL-DB

Så här bygger man om alla index i en SQL-databas.

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) 
		PRINT ‘Reindex index on table: ‘ + @TableName
		FETCH NEXT FROM TableCursor INTO @TableName 
	END 

CLOSE TableCursor 

DEALLOCATE TableCursor