Table: ALL_TAB_COL_STATISTICS
Columns of user's tables, views and clusters
| Column Name | Description |
|---|---|
| AVG_COL_LEN | The average length of the column in bytes |
| COLUMN_NAME | Column name |
| DENSITY | The density of the column |
| GLOBAL_STATS | Are the statistics calculated without merging underlying partitions? |
| HIGH_VALUE | The high value in the column |
| LAST_ANALYZED | The date of the most recent time this column was analyzed |
| LOW_VALUE | The low value in the column |
| NUM_BUCKETS | The number of buckets in histogram for the column |
| NUM_DISTINCT | The number of distinct values in the column |
| NUM_NULLS | The number of nulls in the column |
| OWNER | Table, view or cluster owner |
| SAMPLE_SIZE | The sample size used in analyzing this column |
| TABLE_NAME | Table, view or cluster name |
| USER_STATS | Were the statistics entered directly by the user? |