Feature
USER_PART_COL_STATISTICS displays the column statistics and histograms of the partitions in the partitioned tables owned by the current user.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only MySQL mode.
Related views
ALL_PART_COL_STATISTICS
DBA_PART_COL_STATISTICS
Fields
| Field | Type | Nullable | Description |
|---|---|---|---|
| TABLE_NAME | VARCHAR2(128) | NO | The name of the table. |
| PARTITION_NAME | VARCHAR2(128) | NO | The name of the partition. |
| 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 of 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 the statistics are directly collected.NO: indicates that statistics are not collected or are deduced from the statistics of subpartitions. |
| 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. |