Database statistics generation for SQL Server databases

Guidewire recommends that you only update database statistics during quiet periods, such as weekends or nights, so that these updates do not occur while PolicyCenter is under heavy load. By default, updating statistics on a table or index invalidates existing query plans related to that table or index.

Guidewire requires that you ensure the following options are set to true on the SQL Server database used for PolicyCenter: