The system table <DATABASE_SYSTEM_ADMINISTRATOR>.SYSUPDSTATLOG contains information about the last executed UPDATE STATISTICS statement.
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 |