Overview

Large SQL database tables need to be re-indexed periodically. This can be scheduled to run once a month using SQL Management Studio. Below are sample scripts that can be executed to re-index large tables.


Events Table:

ALTER INDEX ALL ON [unityis].[dbo].[Events] REBUILD


Personnel Table:

ALTER INDEX ALL ON [unityis].[dbo].[Personnel] REBUILD


IMAGE