ALL_TAB_COL_STATISTICS

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

Related Views

• DBA_TAB_COL_STATISTICS provides such information extracted from "DBA_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