Purpose
The ALL_TAB_COL_STATISTICS view displays the column statistics and histograms on the tables accessible to the current user.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
Related views
DBA_TAB_COL_STATISTICSUSER_TAB_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 where the column belongs. |
| 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. |
| LAST_ANALYZED | DATE | YES | The date when the column was analyzed the last time. |
| SAMPLE_SIZE | NUMBER | YES | The sample size during analysis. |
| GLOBAL_STATS | VARCHAR2(3) | YES | YES: indicates that the statistics are directly collected or incrementally maintained.NO: other cases. |
| 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. |
| SCOPE | VARCHAR2(7) | YES | The effective scope of the statistics. |