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

Leave a Reply

Protected with IP Blacklist CloudIP Blacklist Cloud