OWNER |
VARCHAR2(30) |
|
Table owner |
TABLE_NAME |
VARCHAR2(30) |
|
Table name |
COLUMN_NAME |
VARCHAR2(30) |
|
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) |
|
Indicates whether statistics were entered directly by the user (YES) or not (NO) |
AVG_COL_LEN |
NUMBER |
|
Average length of the column (in bytes) |
HISTOGRAM |
VARCHAR2(15) |
|
Indicates existence/type of histogram:
-
NONE
-
FREQUENCY
-
HEIGHT BALANCED
|
