Managing Auto Update Statistics

Review and adjust the Auto Update Statistics (AUS) maintenance system for table statistics.

The AUS maintenance system identifies tables and indexes that require new optimizer statistics and runs the appropriate UPDATE STATISTICS statements to optimize query performance. Depending on your system, you might have to adjust the AUS expiration policies or schedule.

You can control and monitor the AUS policies on the Server Administration > Auto Update Statistics > Config page.

You can review table statistics by using the HCL Informix® Schema Manager Plug-in for OpenAdmin Tool (OAT) on the SQL ToolBox > Schema Manager > Statistics page.

Copyright© 2018 HCL Technologies Limited