3.1 ALL_PART_COL_STATISTICS
ALL_PART_COL_STATISTICS
displays column statistics and histogram information for the table partitions accessible to the current user.
Related Views
-
DBA_PART_COL_STATISTICS
displays column statistics and histogram information for all table partitions in the database. -
USER_PART_COL_STATISTICS
displays column statistics and histogram information for the table partitions owned by the current user. This view does not display theOWNER
column.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Owner of the partitioned table |
|
|
|
Name of the table |
|
|
|
Name of the table partition |
|
|
|
Name of the column |
|
|
|
Number of distinct values in the column |
|
|
|
Low value in the column |
|
|
|
High value in the column |
|
|
|
If a histogram is available on If a histogram is not available on |
|
|
|
Number of NULLs in the column |
|
|
|
Number of buckets in histogram for the column |
|
|
|
Sample size used in analyzing the column |
|
|
|
Date on which the column was most recently analyzed |
|
|
|
|
|
|
|
Indicates whether statistics were entered directly by the user ( |
|
|
|
Additional properties of the statistics, if any. Possible values:
This column can be used to determine whether synopses in the adaptive sampling format have been phased out entirely and purged properly. |
|
|
|
Average length of the column (in bytes) |
|
|
|
Indicates existence/type of histogram:
|
See Also: