Note
This view is introduced since OceanBase Database V3.2.1.
Purpose
This view displays the column statistics and histograms on the partitions in the partitioned tables of the current tenant.
Columns
Column |
Type |
Nullable? |
Description |
|---|---|---|---|
| OWNER | VARCHAR2(128) | NO | The owner of the column. |
| 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 | NO | The number of distinct values in the column. |
| LOW_VALUE | VARCHAR2(128) | NO | The minimum value of the column. |
| HIGH_VALUE | VARCHAR2(128) | NO | The maximum value of the column. |
| DENSITY | NUMBER | NO | The density of the column. |
| NUM_NULLS | NUMBER | NO | The number of NULL values in the column. |
| NUM_BUCKETS | NUMBER | NO | The number of buckets in the histogram on the column. |
| SAMPLE_SIZE | NUMBER | NO | The sample size during analysis. |
| LAST_ANALYZED | DATE | NO | The date when the column was analyzed the last time. |
| GLOBAL_STATS | VARCHAR2(3) | NO | 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) | NO | Indicates whether the partition statistics are set by the user. |
| NOTES | VARCHAR2(80) | NO | Some additional attributes. |
| AVG_COL_LEN | NUMBER | NO | The average length of the column. |
| HISTOGRAM | VARCHAR2(15) | NO | The type of the histogram. |
References
View the column statistics of partitions in the partitioned tables accessible to the current user: ALL_PART_COL_STATISTICS
View the column statistics of partitions in the partitioned tables owned by the current user: USER_PART_COL_STATISTICS
View the column statistics of tables:
View the column statistics of global tables, query the following views:
View the column statistics of subpartitions, query the following views:
View the histogram statistics of tables, query the following views:
View the histogram statistics of partitions, query the following views:
View the histogram statistics of subpartitions, query the following views:
View the index statistics, query the following views:
For more information about how to collect statistics, see the following topics: