how to rebuild index in sql server

Index Rebuild  process drops the existing Index and Recreates the index.

ALTER INDEX ALL ON [dbName].[tblName] REBUILD

Index Reorganize process physically reorganizes the leaf nodes of the index.

ALTER INDEX ALL ON [dbName].[tblName] Reorganize

kleiderweb

Leave a Reply

Protected with IP Blacklist CloudIP Blacklist Cloud

Unable to load the Are You a Human PlayThru™. Please contact the site owner to report the problem.