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