The following table shows the contents of the SYSSTATISTICS system table.
SYSSTATISTICS system table
Column Name
Type
Length
Nullable
Contents
STATID
CHAR
36
false
Unique identifier for the statistic
REFERENCEID
CHAR
36
false
The conglomerate for which the statistic was created (join
with SYSCONGLOMERATES.
CONGLOMERATEID)
TABLEID
CHAR
36
false
The table for which the information is collected
CREATIONTIMESTAMP
TIMESTAMP
29
false
Time when this statistic was created or updated
TYPE
CHAR
1
false
Type of statistics
VALID
BOOLEAN
1
false
Whether the statistic is still valid
COLCOUNT
INTEGER
10
false
Number of columns in the statistic
STATISTICS
org.apache.derby.
catalog.Statistics This class is not part of the public API.
2,147,483,647
true
Statistics information