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.
ALTER INDEX ALL ON [unityis].[dbo].[Events] REBUILD
ALTER INDEX ALL ON [unityis].[dbo].[Personnel] REBUILD