Purpose
The ALL_SUBPART_COL_STATISTICS view displays the column statistics and histograms on the subpartitions in the partitioned tables accessible to the current user.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only MySQL mode.
Related views
DBA_SUBPART_COL_STATISTICS
USER_SUBPART_COL_STATISTICS
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| OWNER | VARCHAR2(128) | NO | The owner of the column. |
| TABLE_NAME | VARCHAR2(128) | NO | The name of the table. |
| SUBPARTITION_NAME | VARCHAR2(128) | NO | The name of the subpartition. |
| COLUMN_NAME | VARCHAR2(128) | NO | The name of the column. |
| NUM_DISTINCT | NUMBER | YES | The number of distinct values in the column. |
| LOW_VALUE | VARCHAR2(128) | YES | The minimum value of the column. |
| HIGH_VALUE | VARCHAR2(128) | YES | The maximum value of the column. |
| DENSITY | NUMBER | YES | The density of the column. |
| NUM_NULLS | NUMBER | YES | The number of NULL values in the column. |
| NUM_BUCKETS | NUMBER | YES | The number of buckets in the histogram on the column. |
| SAMPLE_SIZE | NUMBER | YES | The sample size during analysis. |
| LAST_ANALYZED | DATE | YES | The date when the column was analyzed the last time. |
| GLOBAL_STATS | VARCHAR2(3) | YES | YES: indicates that statistics are collected.NO: indicates that statistics are not collected. |
| USER_STATS | VARCHAR2(3) | YES | Indicates whether the partition statistics are set by the user. |
| NOTES | VARCHAR2(80) | YES | Some additional attributes. |
| AVG_COL_LEN | NUMBER | YES | The average length of the column. |
| HISTOGRAM | VARCHAR2(15) | YES | The type of the histogram. |