Rebuild Lookup Indices

Concepts

Periodically, internal database indices get out of date and need to be rebuilt. Use the index rebuilder tool to rebuild various lookup indices within the database. This tool can also be run from the command line.

The Rebuild Lookup Indices tool should be run in full every three days to ensure that your lookup indices and other values are up-to-date.

When to Use

Be sure to run the index rebuild tool in the following instances:

• after upgrading your version of VSys
• after running the Interactive File Importer (IFI) in VSys
• after GMS Exchange, GMS Transfer or Flat File Import operations in GMS
• after restoring data from a backup
• after any changes to the name lookup rules

Before You Begin

All users except the one running this tool should exit VSys before rebuilding the lookup indices.

Steps in This Task

1. From the VSys One main screen, click Rebuild various lookup indices on the Administrator tools panel.

   

2. All of the check boxes (under Rebuild for:) listing the types of data are checked. If there are any that you do not want to rebuild, click on their check boxes to de-select them.
3. If you want to rebuild the indices for specific people/groups, click on the check box, Just for people in specific groups. Then, specify the groups you want to run it for.
4. Click the Run button.

   The rebuild may take some time depending on how many records of various types are in the database.

   When complete, VSys gives you an on-screen report showing the number and types of records it needed to update.