Show TOC

SYSCHECKSTATISTICSDETAILSLocate this document in the navigation structure

Definition

The database procedure SYSCHECKSTATISTICS writes a detailed log to system table <DATABASE_SYSTEM_ADMINISTRATOR>.SYSCHECKSTATISTICSDETAILS for every table considered by SYSCHECKSTATISTICS.

Structure

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.

More Information