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)