Purpose
The oceanbase.DBA_SUBPART_COL_STATISTICS view displays the column statistics and histograms of all subpartitioned tables of the database.
Note
This view is introduced since OceanBase Database V4.0.0.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| OWNER | varchar(128) | NO | The owner of the partitioned table. |
| TABLE_NAME | varchar(128) | NO | The name of the table. |
| SUBPARTITION_NAME | varchar(128) | NO | The name of the subpartitioned table. |
| COLUMN_NAME | varchar(128) | NO | The name of the column. |
| NUM_DISTINCT | decimal(10,0) | NO | The number of distinct values in the column. |
| LOW_VALUE | varchar(128) | NO | The low value in the column. |
| HIGH_VALUE | varchar(128) | NO | The high value in the column. |
| DENSITY | decimal(10,0) | NO | If you can create a histogram on the COLUMN_NAME column, this column shows the selectivity of the values with zero or one occurrence in the histogram. It does not represent the selectivity of values with two or more occurrences. If COLUMN_NAME is not available on the histogram, the value of this column is 1 or NUM_DISTINCT. |
| NUM_NULLS | decimal(10,0) | NO | The number of NULLs in the column. |
| NUM_BUCKETS | decimal(10,0) | NO | The number of buckets in the histogram of the column. |
| LAST_ANALYZED | datetime(6) | NO | The date when column chromatography was analyzed the last time. |
| SAMPLE_SIZE | decimal(10,0) | NO | The sample size for column chromatography analysis. |
| GLOBAL_STATS | varchar(3) | NO | Indicates whether the statistics have been collected. Valid values: |
| USER_STATS | varchar(3) | NO | Indicates whether the statistics are directly entered by the user. Valid values: |
| NOTES | varchar(80) | NO | The additional properties that describe the statistics. For example, if the value is INCREMENTAL, the global statistics come from the summary, that is, the global statistics are maintained incrementally. |
| AVG_COL_LEN | decimal(10,0) | NO | The average column length, in bytes. |
| HISTOGRAM | varchar(15) | NO | The type of the histogram. Valid values: |