Object documentationSYSUPDATECOUNTERWANTED Locate this document in the navigation structure

 

The system table <DATABASE_SYSTEM_ADMINISTRATOR>.SYSUPDATECOUNTERWANTED displays the tables and indexes for which the statistics counters in the file directory should be initialized.

Structure

SYSUPDATECOUNTERWANTED

SCHEMANAME

CHAR(32)

Schema name of the table whose statistics counters are being initialised

TABLENAME

CHAR(32)

Name of the table whose statistics counters are being initialised

INDEXNAME

CHAR(32)

Name of the index whose statistics counters are being initialised

CANCELCOUNT

FIXED(5)

Specifies the number of cancelled attempts to update the statistics for this object

More Information

FILES

Glossary, File Directory (Database-Internal)