Database Statistics work queue

Code	`DBStats`
Categories	`Schedulable`
Implementation	Work queue
Schedule	Not scheduled
Class	DBStatisticsWorkItemWorkQueue.java

The Database Statistics work queue generates database statistics about how the PolicyCenter application and data model interact with the physical database. For example, database statistics store row counts in a table, how a table distributes the data, and much more. A database management system uses statistics to determine query plans to optimize performance.

Important: Do not run or schedule this process if you set <databasestatistics> attribute useoraclestatspreferences to true in file database-config.xml.

Development mode

In development mode, it is possible to run the Database Statistics proess in any of the following ways:

From a command prompt, using the -updatestatistics option of the system_tools command
From the Execution History tab of the Server Tools Database Statistics screen
As a scheduled batch process

Production mode

In production mode, it is possible to run Database Statistics process in the following ways only:

From a command prompt, using the -updatestatistics option of the system_tools command.
As a scheduled batch process

Guidewire recommendation

Guidewire specifically recommends that you collect full statistics in the following circumstances:

If there are significant changes to data such as after a major upgrade.
If using the zone_import command.
If you are trying to troubleshoot performance problems.

In all other cases, Guidewire recommends that you collect INCREMENTAL database table statistics only.