The <tablestatistics> database configuration element

The <databasestatistics> element in database-config.xml has one subelement, <tablestatistics>. You use this element to override database-wide statistics settings defined on the <databasestatistics> element for a specific table. You can override the databasedegree (Oracle only), samplingpercentage attributes, and statistic gathering behavior of PolicyCenter. You must provide a name parameter to identify the table for which you want to set values:

<tablestatistics name="string" samplingpercentage="integer" databasedegree="integer" 
      action="update|delete|keep|force"/>

By default, PolicyCenter on Oracle does not generate statistics on any table used for processing work items. PolicyCenter deletes any existing statistics on these tables whenever it updates statistics. You can override this behavior by using the action attribute of the <tablestatistics> element. You can set the action attribute to one of the following values:

delete

Delete the statistics on the table. This value does nothing in SQL Server.

force Update statistics for this table while running incremental statistics, regardless of the value of attribute incrementalupdatethreshold on the <databasestatistics> element.

keep

Keep the existing statistics. PolicyCenter does not update statistics for any table for which the user explicitly specifies keep as the value for the action attribute. This value affects any type of database.

update

Update the statistics for the table:
  • Full statistics update - Always update
  • Incremental statistics update - Update only if the change in table data caused by inserts and deletes exceeds the value of attribute incrementalupdatethreshold on the databasestatistics> element.

The default value is update.

The <tablestatistics> element is optional. If you do not specify a <tablestatistics> element for a table, PolicyCenter uses the database-wide statistics defined on the <databasestatistics> element. If you do specify a <tablestatistics> element, you must also supply a value for the action attribute.