Object documentationSYSUPDSTATWANTED Locate this document in the navigation structure

 

The system table <DATABASE_SYSTEM_ADMINISTRATOR>.SYSUPDSTATWANTED contains entries for the tables for which an UPDATE STATISTICS run is useful.

Structure

SYSUPDSTATWANTED

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.

More Information

SYSUPDSTATLOG

SYSCHECKSTATISTICSLOG

Database Administration, SQL Optimizer Statistics

SQL Reference Manual, UPDATE STATISTICS Statement