Updates to database statistics

Updating database statistics can take a long time on a large database. Collect full statistics only if there are significant changes to data such as after a major upgrade. Guidewire recommends that you collect full statistics if using the zone_import command or if there are performance problems. Under standard operating conditions, you generally need to gather incremental database statistics only on a frequent basis.

If you encounter performance problems or degradation related to the database, check the Database Statistics screen on the Info Pages section of the Server Tools. If this screen shows suspicious or inaccurate statistics, update database statistics. If the data change is high, consider using a daily schedule for updating incremental statistics. Use the daily schedule to provide statistics on tables that have had a configurable percentage of data changed since the last statistics process was run.