It is generally a good idea to perform a Pack & Reindex for your database at least once a month. A Pack & Reindex helps your database run at its optimal speeds. The process involves packing & reindexing the tables by completely removing deleted records out of the database and recreating the indexes of the data within the table(s). This could help free up some physical hard drive space from your server and it may result in an increase of database performance as Prevail will be able to run SQL statements quicker and more efficiently.
To run a Pack & Reindex, ensure that all users are signed out of Prevail then click on the “Control Panel” icon to the left, and login. Once you login, click on the “lock database” option and after a few moments the Pack & Reindex option should become available.