16 Mayıs 2011 Pazartesi

DISABLE / ENABLE MSSQL INDEX -TSQL

USE AdventureWorks
GO
----Diable Index
ALTER INDEX [IX_StoreContact_ContactTypeID] ON Sales.StoreContact DISABLE
GO
----Enable Index
ALTER INDEX [IX_StoreContact_ContactTypeID] ON Sales.StoreContact REBUILD
GO

Hiç yorum yok:

Yorum Gönder