Reindex Foreign Keys in the SmarterTrack MSSQL Database

In rare circumstances, the foreign key indexes in your database may no longer exist. This can happen when moving a database to another server, restoring from a backup, or by modifying the database directly. Database administrators can determine if this has occurred by looking at the tables, especially if they notice slightly less than average performance in the management and portal interfaces.

Applies to SmarterTrack 6.x - 9.x

To re-add the foreign key indexes, run the following script:

NOTE: This script only works with SQL Server. It will not work with MySQL.

 

Learn more about SmarterTrack’s live chat, self service portal and knowledge base software.