The system table <DATABASE_SYSTEM_ADMINISTRATOR>.SYSUPDSTATWANTED contains entries for the tables for which an UPDATE STATISTICS run is useful.
SCHEMANAME |
CHAR(32) |
Schema name of the table for which an UPDATE STATISTICS run would be useful |
OWNER |
CHAR(32) |
Owner name of the table for which an UPDATE STATISTICS run would be useful |
TABLENAME |
CHAR(32) |
Name of the table for which an UPDATE STATISTICS run would be useful |
COLUMNNAME |
CHAR(32) |
Name of the column for which an UPDATE STATISTICS run would be useful |
The database kernel enters those table columns in the system table SYSUPDSTATWANTED for which an UPDATE STATISTICS run would appear to be useful, using the kernel automatism or the database procedure SYSCHECKSTATISTICS.
If you use the SQL statement UPDATE STATISTICS AS PER SYSTEM TABLE, an UPDATE STATISTICS run is triggered for all the table (columns) contained in SYSUPDSTATWANTED. Subsequently, the entries from table SYSUPDSTATWANTED are deleted.
The system table SYSUPDSTATWANTED can also be changed by database administrators. However, a database administrator can only insert entries that refer to tables owned by this database administrator.
Database Administration, SQL Optimizer Statistics
SQL Reference Manual, UPDATE STATISTICS Statement