MY_PART_COL_STATISTICS
MY_PART_COL_STATISTICS displays column statistics and histogram information about table partitions owned by the current user. It is accessible to all users. This view exists in both PG_CATALOG and SYS schema.
Name |
Type |
Description |
---|---|---|
table_name |
character varying(128) |
Table name |
partition_name |
character varying(128) |
Table partition name. |
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(63) |
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