SYSSTATISTICS system table The SYSSTATISTICS table describes the statistics within the current database. system tablesSYSSTATISTICS statisticsSYSSTATISTICS system table SYSSTATISTICS system table

The following table shows the contents of the SYSSTATISTICS system table.

SYSSTATISTICS system tableFor each column in the SYSSTATISTICS system table, this table provides its data type, its length in bytes, whether it is nullable, and a description of its contents. 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 false Statistics information