Automated Table Statistics Maintenance

To simplify the complex and repetitive task of the DBA in maintaining current table statistics from which the query plan optimizer can design efficient query plans, HCL OneDB™ provides a table statistics maintenance system, called Auto Update Statistics (AUS). This can automate the identification of tables whose statistics are stale, and can automate the construction and execution of the corresponding UPDATE STATISTICS statements to recalculate their column distributions. The AUS system is provided with built-in criteria for when table statistics should be updated, but the DBA can modify these criteria to reflect current requirements and workloads.

For more information, see the description of the Auto Update Statistics maintenance system in the HCL OneDB Performance Guide. See also the description of the Scheduler, which the DBA can use to specify the policies, resources, and frequency with which the AUS system recalculates table statistics, in the HCL OneDB Administrator's Guide.