MSQL - Disable all nonclustered indexes (vypnutí všech neklastrovaných indexů)
Thursday, February 4, 2010, 08:29 AM
BEGIN TRAN
-- vypne všechny nonclustered indexy (SQL server 2005)
DECLARE @indexName VARCHAR(128)
DECLARE @tableName VARCHAR(128)
DECLARE [indexes] CURSOR FOR
SELECT [sysindexes].[name] AS [Index], [sysobjects].[name] AS [Table]--,*
FROM [sysindexes]
INNER JOIN [sysobjects] ON [sysindexes].[id] = [sysobjects].[id]
WHERE [sysindexes].[name] IS NOT NULL
AND [sysobjects].[type] = 'U'
AND indid<>1 -- není to PK (pk má vždy 1)
AND ([sysindexes].status & 64) = 0 -- vyloučit statistiky (pokud chci statistiky tak <>0)
OPEN [indexes]
FETCH NEXT FROM [indexes] INTO @indexName, @tableName
WHILE @@FETCH_STATUS = 0
BEGIN
exec ( 'ALTER INDEX [' + @indexName + '] ON [' + @tableName + '] DISABLE')
PRINT 'ALTER INDEX [' + @indexName + '] ON [' + @tableName + '] DISABLE'
FETCH NEXT FROM [indexes] INTO @indexName, @tableName
END
CLOSE [indexes]
DEALLOCATE [indexes]
--COMMIT TRAN
ROLLBACK TRAN
| |
( 3.1 / 44 )Veřejné fotky na picasa webu
Wednesday, May 6, 2009, 04:27 PM
Veřejné fotky na picasa webu | |
( 3 / 129 )Fotky z vyjížďky do Říček
Sunday, September 24, 2006, 10:26 PM
| |
( 3.1 / 270 )Tuesday, November 1, 2005, 08:59 AM
| |
( 3.1 / 243 )Fotky z Jitřenky
Saturday, March 5, 2005, 05:01 PM
Jitřenka A
Jitřenka B
| |
( 2.8 / 253 )Next
