-- disable an index ALTER INDEX IX_Contact_EmailAddress ON Person.Contact DISABLE
-- re-enable the index (by rebuilding) ALTER INDEX IX_Contact_EmailAddress ON Person.Contact REBUILD
-- see what indexes are disabled SELECT [NAME], [TYPE_DESC], [IS_DISABLED] FROM SYS.INDEXES WHERE [IS_DISABLED] = 1
No comments:
Post a Comment