Static Data Dictionary Views, 83 of 452

ALL_TAB_COL_STATISTICS

ALL_TAB_COL_STATISTICS provides column statistics and histogram information extracted from "ALL_TAB_COLUMNS".

USER_TAB_COL_STATISTICS provides such information extracted from "USER_TAB_COLUMNS".

Column	Datatype	NULL	Description
`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