The database procedure SYSCHECKSTATISTICS writes a detailed log to system table <DATABASE_SYSTEM_ADMINISTRATOR>.SYSCHECKSTATISTICSDETAILS for every table considered by SYSCHECKSTATISTICS.
EXECUTIONSTART |
TIMESTAMP |
Start time of SYSCHECKSTATISTICS execution |
SCHEMANAME |
CHAR(32) |
Name of the schema of the table examined |
OWNER |
CHAR(32) |
Name of the owner of the table examined |
TABLENAME |
CHAR(32) |
Name of the table examined |
UPDATESTATISTICSSCHEDULED |
CHAR(3) |
YES: the statistics of the table need to be updated NO: otherwise |
REASON |
CHAR(20) |
Explanation of why the statistics of a table need updating or not |
LASTRUNROWCOUNT |
FIXED(10) |
Row count of the table at the time its statistics were determined |
CURRENTROWCOUNT |
FIXED(10) |
Row count of the table at the time SYSCHECKSTATISTICS was executed |
ROWCOUNTCHANGEINPERCENT |
FIXED(10) |
Relative row count change of the table between the time its statistics were determined and the execution of SYSCHECKSTATISTICS (%) |
LASTRUNSIZE |
FIXED(10) |
Size of the table at the time its statistics were determined (KB) |
CURRENTSIZE |
FIXED(10) |
Size of the table at the time SYSCHECKSTATISTICS was executed (KB) |
SIZECHANGEINPERCENT |
FIXED(10) |
Relative size change of the table between the time its statistics were determined and the execution of SYSCHECKSTATISTICS (%) |
The system table SYSCHECKSTATISTICSDETAILS keeps information on SYSCHECKSTATISTICS runs during the last 30 days. You can find information there about the tables that were considered for update statistics and whether and why an update statistics was scheduled.
Database Administration, SQL Optimizer Statistics
SQL Reference Manual, UPDATE STATISTICS Statement