COLUMNGROUPS System Table Description
Description
Information about all the column group statistics on persistent tables in the database.
| This table is for future use. |
Fields
| Field | Type | Description |
|---|---|---|
STATNAME |
string |
Name of the statistics |
SCHEMA |
string |
Name of the schema containing the table containing the statistics |
TABLENAME |
string |
Name of the table containing the statistics |
FIELDCOUNT |
integer |
Number of fields specified in the statistics |
FULLSCAN |
boolean |
When true, a full table scan will be used to generate the statistics |
SAMPLEASPERCENT |
boolean |
Used to specify the sampling rate to use when gererating statistics as follows: false = `SAMPLEVALUE is the number of samples to use` true = `SAMPLEVALUE is the percentage of the table to sample` |
SAMPLEVALUE |
bigint |
The sampling rate to use when updating the statistics as either a percentage or number of samples. See SAMPLEASPERCENT |
HISTOGRAMRESOLUTION |
integer |
The number of histogram buckets created for the statistics. By default, the number of histogram buckets created is 256 |
NORECOMPUTE |
boolean |
When true, disables the automatic update of statistics |
AUTODROP |
boolean |
When true, schema changes will not block any schema changes made by the user, alter/drop column will automatically drop the statistics |