ALL_SUBPART_COL_STATISTICS

ALL_SUBPART_COL_STATISTICS describes column statistics and histogram information for subpartitions of partitioned objects accessible to the current user.

Related Views

• DBA_SUBPART_COL_STATISTICS provides this information for all subpartitions in the database.
• USER_SUBPART_COL_STATISTICS provides this information for subpartitions of all partitioned objects owned by the current user. This view does not display the OWNER column.

  Column	Datatype	NULL	Description
  OWNER	VARCHAR2(30)	NOT NULL	Owner name
  TABLE_NAME	VARCHAR2(30)	NOT NULL	Table name
  SUBPARTITION_NAME	VARCHAR2(30)		Table subpartition 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
  SAMPLE_SIZE	NUMBER		Sample size used in analyzing this column
  LAST_ANALYZED	DATE		Date on which this column was most recently analyzed
  GLOBAL_STATS	VARCHAR2(3)		Indicates whether column statistics for the subpartition were collected by analyzing the table as a whole (YES) or estimated from statistics gathered on 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