The `<databasestatistics>` database configuration element

The <database> element in file database-config.xml contains a single occurrence of subelement <databasestatistics>. Use this element to control how PolicyCenter generates database statistics statements.

The <databasestatistics> element has the following syntax. The following code sample shows required attributes in bold font.

<database>

   <databasestatistics databasedegree="integer" incrementalupdatethresholdpercent="integer"
        numappserverthreads="integer" samplingpercentage="integer" 
        useoraclestatspreferences="true|false">
    
    <!-- Sets database statistics options for the named table -->
    <tablestatistics action="delete|keep|update|force" databasedegree="integer" name="string"
          samplingpercentage="integer">
      
    <!-- Sets database statistics options for the named column on the named table -->
    <histogramstatistics name="string" numbbuckets="integer" />

     </tablestatistics>

   </databasestatistics>

 </database>

The following list describes the attributes that you can configure on the <databasestatistics> element. All of these attributes are optional. See The <databasestatistics> database configuration element for more information on these attributes.

`databasedegree`	On Oracle, this attribute controls the degree of database parallelism that Oracle uses in executing each individual statement. The default is 1. PolicyCenter uses the value of this attribute for all statements. SQL Server ignores the `databasedegree` attribute.
`incrementalupdatethresholdpercent`	This attribute specifies the percentage of table data that must have changed since the last statistics process for the incremental statistics generation batch process to update statistics for the table.
`numappserverthreads`	On both Oracle and SQL Server, the `numappserverthreads` attribute controls the number of threads that PolicyCenter uses to update database statistics for staging tables during import only.
`samplingpercentage`	The behavior of this attribute depends on the database type. For Oracle, Guidewire recommends that you always set this value to 0 to enable Oracle auto-sampling.
`useoraclestatspreferences`	On Oracle, this attribute sets the database statistics preferences to be able to use the Oracle Autotask infrastructure instead of the `DBStats` batch process from PolicyCenter. The default is `false`, which requires that you disable the Autotask and schedule `DBStats` batch processing in its place. Changes to the value of this attribute only take effect during an application upgrade.

The <databasestatistics> element has the following subelement.

tablestatistics

Provides overrides of database-wide statistics settings defined on the <databasestatistics> element for a specific table. There can be multiple occurrences of the <tablestatistics> subelement on the <databasestistics> element.