Update statistics on tables that exceed a change threshold

About this task

This process does not update statistics on any table that contains locked statistics.

Procedure

  1. Ensure that the PolicyCenter is running.
  2. Open a command prompt and navigate to the following location in the PolicyCenter installation directory:
    • admin/bin
  3. Enter the following command to update statistics for tables exceeding the change threshold.
    • system_tools -password password -updatestatistics description true

    The PolicyCenter administration command prompt tools all require that you enter the password of an administrative user for the tool to work. The use of a user name is optional.