Rebuilding As users add, delete and update document records, the SQL database can become fragmented. The rebuild index function defragments the selected SQL database, and may also repair or create any damaged or missing database indexes. Rebuilding the Index may not be needed as part of regular maintenance, but is recommended if you notice that performance is slowing. If you have deleted an Archive with records in it, you will be prompted to rebuild the Index. The rebuilding process should take less than a minute to complete. Everyone should be logged out of the database during the rebuilding process.
- To rebuild the Index data in the
ssFieldstable in SQL, click the More Options (
) icon in the selected database bar. - Click Rebuild Index.
...