Object documentationSYSUPDSTATLOG Locate this document in the navigation structure

 

The system table <DATABASE_SYSTEM_ADMINISTRATOR>.SYSUPDSTATLOG contains information about the last executed UPDATE STATISTICS statement.

Structure

SYSUPDSTATLOG

SCHEMANAME

CHAR(32)

Name of the table schema

TABLENAME

CHAR(32)

Name of the table

TABLEID

CHAR(8) BYTE

Internal ID of the table

COLUMNNAME

CHAR(32)

Name of the column

INDEXNAME

CHAR(32)

Name of the index

EXECUTED_AT

TIMESTAMP

Time of the start of the SQL statement which executes several UPDATE STATISTICS

IMPLICIT

CHAR(3)

No longer used

SAMPLE_PCT

FIXED(3)

Area of the table (in %) which is read for the UPDATE STATISTICS run

SAMPLE_ROW

FIXED(10)

Number of lines in the table which are read for the UPDATE STATISTICS run

EXECUTION_START

TIMESTAMP

Time of the start of the UPDATE STATISTICS run

EXECUTION_END

TIMESTAMP

Time of the end of the UPDATE STATISTICS run

SESSION

FIXED(10)

ID of the database session

TERMID

CHAR(18)

ID of the terminal used by the logged-on application

SEQNO

FIXED(5)

No longer used

More Information

SYSUPDSTATWANTED

SQL Reference Manual, UPDATE STATISTICS Statement