home - keyword index

Keyword: JOIN

jump to Columns back to index

Tables

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
top back to index

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
top back to index

Comment on this page:




home - keyword index