Skip to content

Latest commit

 

History

History
30 lines (23 loc) · 673 Bytes

SQL - SQL Server - Re-build all Indexes.md

File metadata and controls

30 lines (23 loc) · 673 Bytes

SQL - Re-build all Indexes

Source: Rebuild all indexes online | thiscodeWorks

-- rebuild all indexes online
ALTER INDEX ALL ON Table1
REBUILD WITH (ONLINE = ON);   
GO  
-- rebuild single index online
ALTER INDEX IX_IndexName ON Table1
REBUILD WITH (ONLINE = ON);   
GO  

Appendix: Links

Backlinks:

list from [[SQL - Re-build all Indexes]] AND -"Changelog"