Purpose
The oceanbase.DBA_TAB_HISTOGRAMS view displays the column histograms of all tables in the database.
Note
This view is introduced since OceanBase Database V4.0.0.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| OWNER | varchar(128) | NO | The owner of the table. |
| TABLE_NAME | varchar(128) | NO | The name of the table. |
| COLUMN_NAME | varchar(128) | NO | The name or attribute of the object type column. |
| ENDPOINT_NUMBER | decimal(10,0) | NO | The number of buckets in the histogram. |
| ENDPOINT_VALUE | decimal(10,0) | NO | The standardized endpoint value for the bucket. |
| ENDPOINT_ACTUAL_VALUE | text | NO | The actual (non-standardized) string of the endpoint value for the bucket. |
| ENDPOINT_ACTUAL_VALUE_RAW | text | NO | The actual value of the endpoint in the original format. |
| ENDPOINT_REPEAT_COUNT | decimal(10,0) | NO | The endpoint frequency (only for hybrid histograms). The value is 0 for other types of histograms. |
| SCOPE | varchar(7) | NO | Indicates whether statistics are collected from any table other than global temporary tables. For global temporary tables, the value can be: SESSION: indicates that the statistics are session-specific.SHARED: indicates that statistics are shared across all sessions. |