The following option in SQL server provides you to rebuild the index online.
SYNTAX
ALTER INDEX INDEX_NAME
ON TABLE_NAME REBUILD WITH (ONLINE = ON)
EXAMPLE
ALTER INDEX IX_NAME
ON StudentMarks REBUILD WITH (ONLINE = ON)
No comments:
Post a Comment