Updated on 2025-07-22 GMT+08:00

MY_INDEXES

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

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.