Object documentationSYSCHECKSTATISTICSLOG Locate this document in the navigation structure

 

The system table <DATABASE_SYSTEM_ADMINISTRATOR>.SYSCHECKSTATISTICSLOG logs all calls of the database procedure SYSCHECKSTATISTICS.

Structure

SYSCHECKSTATISTICSLOG

EXECUTIONSTART

TIMESTAMP

Start time of SYSCHECKSTATISTICS call

EXECUTIONEND

TIMESTAMP

End time of SYSCHECKSTATISTICS call

CALLER

CHAR(32)

Name of the user calling SYSCHECKSTATISTICS

TABLECOUNT

FIXED(5)

Number of tables with an entry in the system table SYSUPDSTATWANTED

RETURNCODE

FIXED(5)

Returncode of SYSCHECKSTATISTICS call.

The database procedure SYSCHECKSTATISTICS checks the growth of all tables owned by the current database user. If the current size of a table differs more than CHANGETHRESHOLD percent from the table size at last update statistics run, the database procedure SYSCHECKSTATISTICS inserts for this table the relevant information into the system table SYSUPDSTATWANTED. If the database procedure SYSCHECKSTATISTICS is called by the database system administrator the described check is performed for all tables in the database system.

More Information

SYSUPDSTATWANTED

Database Administration, SQL Optimizer Statistics

SQL Reference Manual, UPDATE STATISTICS Statement