Statistics and the database configuration file

File database-config.xml contains a single <databasestatistics> element, which has the following format.

<databasestatistics samplingpercentage="integer" databasedegree="integer"
 incrementalupdatethresholdpercent="integer">
    <tablestatistics name="string" samplingpercentage="integer" databasedegree="integer"
          action="delete|keep|update"> 
      <histogramstatistics name="string" numbuckets="integer" />
    ...
  </tablestatistics>
  ...
</databasestatistics>

In the following example, an Oracle database connection shows the use of these parameters:

<databasestatistics samplingpercentage="0" databasedegree="4" incrementalupdatethresholdpercent ="15">
  <tablestatistics name="pc_table1" samplingpercentage="0" databasedegree="4">
    <histogramstatistics name="scheduledsenddate" numbuckets="254"/>
  </tablestatistics>
  <tablestatistics name="pc_table2" action="delete" />
</databasestatistics>

The previous example configures the following database statistic generation behavior:

Collects statistics on all PolicyCenter tables using the automatic sampling size and with a degree of parallelism of 4.
Samples table pc_table1 using Oracle AUTO_SAMPLE_SIZE, which is the recommended value.
Uses a parallel degree of 4.
Defines a histogram with 254 buckets (time slots) on pc_check.scheduledsenddate. Guidewire requires that you provide a value for this attribute.
Deletes statistics on pc_table2 due to the attribute action="delete".