|
TABLE_NAME
|
VARCHAR2(30)
|
NOT NULL
|
Table name
|
|
COLUMN_NAME
|
VARCHAR2(30)
|
NOT NULL
|
Column name
|
|
NUM_DISTINCT
|
NUMBER
|
|
Number of distinct values in the column
|
|
LOW_VALUE
|
RAW(32)
|
|
Low value in the column
|
|
HIGH_VALUE
|
RAW(32)
|
|
High value in the column
|
|
DENSITY
|
NUMBER
|
|
Density of the column
|
|
NUM_NULLS
|
NUMBER
|
|
Number of nulls in the column
|
|
NUM_BUCKETS
|
NUMBER
|
|
Number of buckets in histogram for the column
|
|
LAST_ANALYZED
|
DATE
|
|
Date on which this column was most recently analyzed
|
|
SAMPLE_SIZE
|
NUMBER
|
|
Sample size used in analyzing this column
|
|
GLOBAL_STATS
|
VARCHAR2(3)
|
|
For partitioned tables, indicates whether column statistics were collected for the table as a whole (YES) or were estimated from statistics on underlying partitions and subpartitions (NO).
|
|
USER_STATS
|
VARCHAR2(3)
|
|
Were the statistics entered directly by the user?
|
|
AVG_COL_LEN
|
NUMBER
|
|
The average length of the column, in bytes
|
