The system table SYSUPDATECOUNTERWANTED displays the tables and indexes for which the statistics counters in the file directory should be initialized.
SYSUPDATECOUNTERWANTED
SCHEMANAME |
CHAR(32) |
Name of the schema |
TABLENAME |
CHAR(32) |
Name of the table |
INDEXNAME |
CHAR(32) |
Name of the index |
CANCELCOUNT |
FIXED(5) |
Specifies the number of cancelled attempts to update the statistics for this object |
See also:
Glossary, Run Directory