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 |