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