ALL_SUBPART_COL_STATISTICS
describes column statistics and histogram information for subpartitions of partitioned objects accessible to the current user.
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(4000) |
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) |
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:
|