Font size:

SYSSTATISTICS

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			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