Run Reindex Database

The PCS database uses indexes to accelerate the process of locating records in the database. As you add and delete records, these indexes become fragmented which in turn slow down database performance. The Reindex Database process restores database efficiency by updating the indexes.

Before running Reindex Database, it is recommended that you make a backup of the PCS database using Microsoft SQL Server Management Studio (SSMS). For more information about SSMS, see the AI document entitled PCS Database Backup and Restore.

To run Reindex Database:

  1. Click Tools > Job Service Viewer to open the Job Service Console window.

    Job Service Console

    Job Service Console

  2. Click Reindex Database.

  3. When a warning message opens, click Yes to continue the reindexing process.

    Warning Message

    Warning Message

    Status information displays in the queue while running Reindex Database. When the process completes, status information then displays in the Job History pane.