Updated on 2023-10-31 GMT+08:00

USER_IND_PARTITIONS

USER_IND_PARTITIONS displays information about index partitions accessible to the current user.

Name

Type

Description

index_owner

character varying(64)

Name of the owner of the partitioned index to which the index partition belongs

schema

character varying(64)

Schema of the partitioned index to which the index partition belongs

index_name

character varying(64)

Index name of the partitioned table to which the index partition belongs

partition_name

character varying(64)

Name of the index partition

index_partition_usable

boolean

Whether the index partition is available

high_value

text

Boundary of the table partition corresponding to the index partition. For a range partition, the boundary is the upper boundary. For a list partition, the boundary is the boundary value set.

Reserved field for forward compatibility. The parameter pretty_high_value is added in version 8.1.3 to record the information.

pretty_high_value

text

Boundary of the table partition corresponding to the index partition. For a range partition, the boundary is the upper boundary. For a list partition, the boundary is the boundary value set.

The query result is the instant decompilation output of the partition boundary expression. The output of this column is more detailed than that of high_value. The output information can be collation and column data type.

def_tablespace_name

name

Tablespace name of the index partition