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 both PG_CATALOG and SYS schema.
Name |
Type |
Description |
---|---|---|
table_name |
character varying(128) |
Table name. |
subpartition_name |
character varying(128) |
Name of a level-2 partition in a table. |
column_name |
character varying(4000) |
Column name. |
num_distinct |
numeric |
Not supported. Its value is NULL. |
low_value |
raw |
Not supported. Its value is NULL. |
high_value |
raw |
Not supported. Its value is NULL. |
density |
numeric |
Not supported. Its value is NULL. |
num_nulls |
numeric |
Not supported. Its value is NULL. |
num_buckets |
numeric |
Not supported. Its value is NULL. |
sample_size |
numeric |
Not supported. Its value is NULL. |
last_analyzed |
date |
Not supported. Its value is NULL. |
global_stats |
character varying(3) |
Not supported. Its value is NULL. |
user_stats |
character varying(3) |
Not supported. Its value is NULL. |
notes |
character varying(41) |
Not supported. Its value is NULL. |
avg_col_len |
numeric |
Not supported. Its value is NULL. |
histogram |
character varying(15) |
Not supported. Its value is NULL. |
schema |
character varying(64) |
Name of the namespace to which the column belongs. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot