SYSUPDSTATWANTED

Definition

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

Structure

SYSUPDSTATWANTED

SCHEMANAME

CHAR(32)

Name of the schema

OWNER

CHAR(32)

Name of the owner

TABLENAME

CHAR(32)

Name of the table

COLUMNNAME

CHAR(32)

Name of the column

The database kernel enters those table columns in the system table SYSUPDSTATWANTED for which an UPDATE STATISTICS run would appear to be useful.

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 reference tables owned by that database administrator.

See also:

SQL Reference Manual, UPDATE STATISTICS Statement (update_statistics_statement)