27.12. pga_table_column_stats Metadata Table #

This metadata table contains statistics of analytical table columns.

Column Name

Column Type

Constraint

Description

column_id

BIGINT

Primary key, foreign key

The ID of the column from the pga_column metadata table.

contains_null

BOOLEAN

NOT NULL

Specifies whether the column can contain NULL values.

Possible values:

  • true

  • false

contains_nan

BOOLEAN

-

Specifies whether the column can contain NaN values.

Possible values:

  • true

  • false

This is relevant only for FLOAT, DOUBLE, and NUMERIC data types.

min_value

VARCHAR

-

The minimum column value.

It is displayed as a string for consistency and must be converted to the current column data type when used.

max_value

VARCHAR

-

The maximum column value.

It is displayed as a string for consistency and must be converted to the current column data type when used.