Managing database statistics using system tools

You can use the system_tools command options to explicitly update database statistics or to generate the SQL statements to update statistics. It is possible to update database statics fully or incrementally.

Full database statistics	Generates database statistics for every table in the PolicyCenter database.
Incremental database statistics	Generates database statistics for tables for which the change in the table data caused by inserts and deletes exceeds a certain percentage threshold. You specify this threshold through the `incrementalupdatethresholdpercent` attribute on the `<databasestatistics>` element in file database-config.xml. The default is 10 percent.

It is possible to pause the database statistics updating process, just as you can with other work queues. Use the Server Tools Work Queue Info page to pause an in-progress work queue.