Rebuild an Index in SQL

08/23/21

A script for improving your database performance by using this SQL command to Rebuild an Index.

--Basic Rebuild Command
ALTER INDEX Index_Name ON Table_Name REBUILD
 
--REBUILD Index with ONLINE OPTION
ALTER INDEX Index_Name ON Table_Name REBUILD WITH(ONLINE=ON) | WITH(ONLINE=ON)

We're available if you need assistance implementing custom SQL code. Contact us for help!

Share This: 

Related Resources

envelope