How to Enable/Disable Indexes?

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

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

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

What is Normalization?

Database normalization is a data design and organization process applied to data structures based on rules that help building relational dat...