Purpose
The USER_PART_COL_STATISTICS view 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 the MySQL mode.
Related views
ALL_PART_COL_STATISTICSDBA_PART_COL_STATISTICS
Columns
| Column | 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 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 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 properties. |
| AVG_COL_LEN | NUMBER | YES | The average length of the column. |
| HISTOGRAM | VARCHAR2(15) | YES | The type of the histogram. |