MY_SUBPART_COL_STATISTICS
MY_SUBPART_COL_STATISTICS displays column statistics and histogram information about level-2 partitions of partitioned objects owned by the current user. All users can access this view. This view exists in the PG_CATALOG and SYS schemas.
| Name | Type | Description |
|---|---|---|
| table_name | character varying(128) | Table name. |
| subpartition_name | character varying(128) | Name of a level-2 partition. |
| column_name | character varying(4000) | Column name. |
| num_distinct | numeric | Not supported. Set it to NULL. |
| low_value | raw | Not supported. Set it to NULL. |
| high_value | raw | Not supported. Set it to NULL. |
| density | numeric | Not supported. Set it to NULL. |
| num_nulls | numeric | Not supported. Set it to NULL. |
| num_buckets | numeric | Not supported. Set it to NULL. |
| sample_size | numeric | Not supported. Set it to NULL. |
| last_analyzed | timestamp(0) without time zone | Not supported. Set it to NULL. |
| global_stats | character varying(3) | Not supported. Set it to NULL. |
| user_stats | character varying(3) | Not supported. Set it to NULL. |
| notes | character varying(41) | Not supported. Set it to NULL. |
| avg_col_len | numeric | Not supported. Set it to NULL. |
| histogram | character varying(15) | Not supported. Set it to NULL. |
| schema | character varying(64) | Name of the namespace to which the column belongs. |
