The system table <DATABASE_SYSTEM_ADMINISTRATOR>.SYSUPDATECOUNTERWANTED displays the tables and indexes for which the statistics counters in the file directory should be initialized.
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 |