Show TOC

SYSUPDATECOUNTERWANTEDLocate this document in the navigation structure

Definition

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

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