SYSUPDSTATLOG
The system table <DATABASE_SYSTEM_ADMINISTRATOR>.SYSUPDSTATLOG
contains information about the last executed UPDATE STATISTICS
statement.
|
CHAR(32) |
Name of the table schema |
|
CHAR(32) |
Name of the table |
|
CHAR(8) BYTE |
Internal Identification of the table |
|
FIXED(5) |
Identification of the partition |
|
CHAR(32) |
Name of the column |
|
CHAR(32) |
Name of the index |
|
TIMESTAMP |
Time of the start of the SQL statement which executes several UPDATE STATISTICS |
|
CHAR(3) |
No longer used |
|
FIXED(3) |
Area of the table (in %) which is read for the UPDATE STATISTICS run |
|
FIXED(10) |
Number of lines in the table which are read for the UPDATE STATISTICS run |
|
TIMESTAMP |
Time of the start of the UPDATE STATISTICS run |
|
TIMESTAMP |
Time of the end of the UPDATE STATISTICS run |
|
FIXED(10) |
Identification of the database session |
|
CHAR(18) |
Identification of the terminal used by the logged-on application |
|
FIXED(5) |
No longer used |