Generate statistics SQL for all tables

About this task

You can use the results purely as a reference, or you can edit the statements and execute them outside of PolicyCenter.

Procedure

  1. Ensure that the PolicyCenter server 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 generate database statistic SQL statements for all tables.
    • system_tools -password password -getdbstatisticsstatements

    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.

Results

PolicyCenter groups the output statements by table.