Help Center/ Data Warehouse Service/ Standard Data Warehouse (9.1.0.x)/ GaussDB(DWS) System Catalogs and Views/ System Views/ DBA_INDEXES
Updated on 2025-06-12 GMT+08:00
DBA_INDEXES
DBA_INDEXES displays all indexes in the database. This view is accessible only to users with system administrator rights.
| Column | 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 | Whether the index is unique |
| generated | character varying(1) | Whether the index name is generated by the system |
| partitioned | character(3) | Whether the index has the property of the partition table |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
The system is busy. Please try again later.
