Interview Questions on .Net and Msbi Technologies

7/07/2012

How to Enable/Disable Indexes?

--Disable Index
ALTER INDEX [IndexName] ON TableName DISABLE
GO

--Enable Index
ALTER INDEX [IndexName] ON TableName REBUILD
GO

No comments :

Post a Comment

Subscribe to: Post Comments ( Atom )