Updated on 2024-05-07 GMT+08:00

MY_TAB_HISTOGRAMS

MY_TAB_HISTOGRAMS displays histogram information about the tables or views 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.

column_name

character varying(4000)

Column name or attribute of an object column

endpoint_number

numeric

Bucket ID of the histogram

endpoint_value

numeric

Not supported. Its value is NULL.

endpoint_actual_value

character varying(4000)

Actual value of the bucket endpoint

endpoint_actual_value_raw

raw

Not supported. Its value is NULL.

endpoint_repeat_count

numeric

Not supported. Its value is NULL.

scope

character varying(7)

Not supported. Its value is SHARED.