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 |