Keyword: EXPRESSION
jump to Columns back to indexTables
| Table Name | Description |
|---|---|
| ALL_CLUSTER_HASH_EXPRESSIONS | Hash functions for all accessible clusters |
| ALL_IND_EXPRESSIONS | FUNCTIONAL INDEX EXPRESSIONs on accessible TABLES |
| DBA_CLUSTER_HASH_EXPRESSIONS | Hash functions for all clusters |
| DBA_IND_EXPRESSIONS | FUNCTIONAL INDEX EXPRESSIONs on all TABLES and CLUSTERS |
| USER_CLUSTER_HASH_EXPRESSIONS | Hash functions for the user's hash clusters |
| USER_IND_EXPRESSIONS | Functional index expressions in user's indexes and indexes on user's tables |
Columns
| Column Name | Description |
|---|---|
| COLUMN_EXPRESSION (ALL_IND_EXPRESSIONS) | Functional index expression defining the column |
| COLUMN_EXPRESSION (USER_IND_EXPRESSIONS) | Functional index expression defining the column |
| COLUMN_EXPRESSION (DBA_IND_EXPRESSIONS) | Functional index expression defining the column |
| HASH_EXPRESSION (DBA_CLUSTER_HASH_EXPRESSIONS) | Text of hash function of cluster |
| HASH_EXPRESSION (ALL_CLUSTER_HASH_EXPRESSIONS) | Text of hash function of cluster |
| HASH_EXPRESSION (USER_CLUSTER_HASH_EXPRESSIONS) | Text of hash function of cluster |