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 the PG_CATALOG and SYS schemas.
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. 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 |
date |
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(63) |
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. |
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