Updated on 2024-06-03 GMT+08:00

MY_TAB_HISTOGRAMS

MY_TAB_HISTOGRAMS displays histogram information about the tables and views owned by the current user. All users can access this view. This view exists in the PG_CATALOG and SYS schemas.

Table 1 MY_TAB_HISTOGRAMS columns

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. The value is NULL.

endpoint_actual_value

character varying(4000)

Actual value of the bucket endpoint.

endpoint_actual_value_raw

raw

Not supported. The value is NULL.

endpoint_repeat_count

numeric

Not supported. The value is NULL.

scope

character varying(7)

Not supported. The value is SHARED.