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 |
Previous Page
Next Page
Table of Contents
Index