Understanding database statistics

Database statistics are metadata that describe the underlying database. For example, database statistics store row counts in a table, the distribution of data in the table, and much more. A database management system uses statistics to determine query plans to optimize performance.

PolicyCenter provides database statistics generation designed specifically for how the PolicyCenter application and data model interact with the physical database.

Use the Server Tools Database Statistics screen to determine if any statistics are out of date. Guidewire recommends that you archive database statistics as standard practice. This ensures that you have a record of the database history that you can review, if it becomes necessary.