Show TOC

Object documentationSYSUPDSTATWANTED

 

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)

Name of the schema of the table for which an UPDATE STATISTICS run would be useful

OWNER

CHAR(32)

Name of the owner 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

PARTITIONID

FIXED(5)

Identification of the partition

COLUMNNAME

CHAR(32)

Name of the column for which an UPDATE STATISTICS run would be useful

REQUESTTIMESTAMP

TIMESTAMP

Time this row was inserted into the table

INITIATOR

CHAR(32)

Name of user who inserted this row into the table

Database Internal: The database system itself inserted this row

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