Understanding database statistics batch processing
PolicyCenter
uses Database Statistics batch processing DBStats to generate database statistics.
The database statistics batch process is resource-intensive. To prevent
an accidental start of this process, you cannot start Database Statistics
from the Server Tools Batch Process
Info screen. Instead, you must start the process manually
from a command prompt.
Important: Consult with your
Database Administrator before starting the database statistics process.
Some PolicyCenter batch processes use work or scratch tables to store intermediate calculations. Other batch processes populate denormalized tables that PolicyCenter uses internally for performance reasons. These processes can update database statistics on the scratch tables and denormalized tables during their execution.