Purpose
The USER_TAB_COL_STATISTICS view displays the column statistics and histograms of tables owned by the current user.
Applicability
This view applies only to OceanBase Database in Oracle mode.
References
ALL_TAB_COL_STATISTICS
DBA_TAB_COL_STATISTICS
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| TABLE_NAME | VARCHAR2(128) | NO | The name of the table that contains the column. |
| 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 in the column. |
| HIGH_VALUE | VARCHAR2(128) | YES | The maximum value in 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 column's histogram. |
| LAST_ANALYZED | DATE | YES | The time when the statistics were last analyzed. |
| SAMPLE_SIZE | NUMBER | YES | The sample size used during the analysis. |
| GLOBAL_STATS | VARCHAR2(3) | YES | YES: the statistics are directly collected or incrementally maintainedNO: other cases |
| USER_STATS | VARCHAR2(3) | YES | Whether the partition statistics are user-defined. |
| NOTES | VARCHAR2(80) | YES | Additional attributes. |
| 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 scope of the statistics. |