Keyword: JOIN
jump to Columns back to indexTables
| Table Name | Description |
|---|---|
| ALL_DIM_JOIN_KEY | Representation of a join between two dimension tables. |
| ALL_JOIN_IND_COLUMNS | Join Index columns comprising the join conditions |
| ALL_MVIEW_JOINS | Description of a join between two columns in the WHERE clause of a materialized view accessible to the user |
| ALL_SUMMARY_JOINS | |
| DBA_DIM_JOIN_KEY | Representation of a join between two dimension tables. |
| DBA_JOIN_IND_COLUMNS | Join Index columns comprising the join conditions |
| DBA_MVIEW_JOINS | Description of a join between two columns in the WHERE clause of a materialized view accessible to dba |
| DBA_SUMMARY_JOINS | |
| USER_DIM_JOIN_KEY | Representation of a join between two dimension tables. |
| USER_JOIN_IND_COLUMNS | Join Index columns comprising the join conditions |
| USER_MVIEW_JOINS | Description of a join between two columns in the WHERE clause of a materialized view created by the user |
| USER_SUMMARY_JOINS |
Columns
| Column Name | Description |
|---|---|
| CHILD_JOIN_COLUMN (USER_DIM_JOIN_KEY) | Name of the join column |
| CHILD_JOIN_COLUMN (DBA_DIM_JOIN_KEY) | Name of the join column |
| CHILD_JOIN_COLUMN (ALL_DIM_JOIN_KEY) | Name of the join column |
| JOIN_INDEX (USER_INDEXES) | Is this index a join index? |
| JOIN_INDEX (IND) | Is this index a join index? |
| JOIN_INDEX (ALL_INDEXES) | Is this index a join index? |
| JOIN_INDEX (DBA_INDEXES) | Is this index a join index? |
| JOIN_KEY_ID (DBA_DIM_CHILD_OF) | Keys that join child uniquely to the parent |
| JOIN_KEY_ID (ALL_DIM_CHILD_OF) | Keys that join child uniquely to the parent |
| JOIN_KEY_ID (USER_DIM_CHILD_OF) | Keys that join child uniquely to the parent |
| JOIN_POS (USER_OUTLINE_HINTS) | Position of the table in the join order |
| JOIN_POS (ALL_OUTLINE_HINTS) | Position of the table in the join order |
| JOIN_POS (DBA_OUTLINE_HINTS) | Position of the table in the join order |