SYSSTATISTICS system table

Describes the schemas within the current database. Column Name Type Length Nullability 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 false time when this statistic was created or updated TYPE CHAR 1 false type of statistics VALID BOOLEAN false whether the statistic is still valid COLCOUNT INTEGER false number of columns in the statistic STATISTICS org.apache. derby.catalog. Statistics: This class is not part of the public API. true statistics information