Help Center> Data Warehouse Service> Developer Guide> System Catalogs and System Views> System Views> DBA_IND_EXPRESSIONS
DBA_IND_EXPRESSIONS
DBA_IND_EXPRESSIONS displays the information about expression indexes in the database. It is accessible only to users with system administrator rights.
| Name | Type | Description |
|---|---|---|
| index_owner | character varying(64) | Index owner |
| index_name | character varying(64) | Index name |
| table_owner | character varying(64) | Table owner |
| table_name | character varying(64) | Table name |
| column_expression | text | The function-based index expression of a specified column |
| column_position | smallint | Position of column in the index |
Parent topic: System Views
Last Article: DBA_IND_COLUMNS
Next Article: DBA_IND_PARTITIONS
Did this article solve your problem?
Thank you for your score！Your feedback would help us improve the website.