Refresh Archive Statistics

Like most database systems, the CopyStorm/Archive system will operate most efficiently when its has statistics about what is stored in archives. Example:

  • If CopyStorm knows what tables have been archived by a policy then it can limit searches to just these tables.
  • If CopyStorm knows how may records are in an archive it can generated more efficient SQL queries.

For the most part, CopyStorm/Archive updates statistics without any user intervention. This page, however, describes how to force CopyStorm/Archive to update statistics if the most accurate statistics possible are desired or if the statistics have been corrupted. Note: it is unlikely that you will ever need this feature.

The Update Statistics feature is accessed from the right-click context menu on the CopyStorm Archive tab.

In the Refresh Statistics dialog there is the option to refresh statistics for a single archive or for all archives in the system. The following image illustrates what the screen may look like after refreshing statistics for a single archive.