SYSSTATISTICS system table
Derby Reference Manual
234
Column Name
Type
Length
Nullable
Contents
LASTCOMPILED
TIMESTAMP
29
true
Time that the
statement was
compiled
COMPILATIONSCHEMAID
CHAR
36
false
ID of the schema
containing the
statement
USINGTEXT
LONG VARCHAR
32,700
true
Text of the
USING clause
of the CREATE
STATEMENT
and ALTER
STATEMENT
statements
SYSSTATISTICS system table
The SYSSTATISTICS table describes the statistics within the current database.
The following table shows the contents of the SYSSTATISTICS system table.
Table 57.
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
