Help Center/GaussDB/Developer Guide(Distributed_V2.0-2.x)/System Catalogs and System Views/System Views/MY_INDEXES
Updated on 2025-08-19 GMT+08:00
View PDF

MY_INDEXES

MY_INDEXES displays index information about the current user. This view exists in both PG_CATALOG and SYS schema.

Table 1 MY_INDEXES columns

Name

Type

Description

owner

character varying(64)

Index owner.

index_name

character varying(64)

Index name.

table_name

character varying(64)

Name of the table corresponding to the index.

uniqueness

text

Specifies whether the index is unique.

partitioned

character(3)

Specifies whether the index has the property of partitioned tables.

generated

character varying(1)

Specifies whether the index name is generated by the system.

Parent topic:System Views