Join nodes represent relational join operations
that allow retrieval of data from two or more tables based on matching
column values.
- NLJOIN
- An
NLJOIN node indicates an operation called a nested loop join.
The NLJOIN node is the defining node of a nested loop join construct.
- STARJOIN
- A STARJOIN node indicates
an operation called a data manager pushdown
star join. The STARJOIN node is the defining node for a star join
construct.
This node does not indicate the other type of star join,
which is called a relational data services star join.
A relational data services star join is represented by a particular
construct for relational data services star joins.
- MSJOIN
- An MSJOIN node indicates an operation
called a merge scan join,
also known as a merge join or a sort merge join. The MSJOIN node is
the defining node for a merge scan join construct.
- SEMIJOIN
- A SEMIJOIN node represents the merging
of the outer table records
with one of the indexes on the inner table during a hybrid join.
- HBJOIN
- An HBJOIN node indicates an
operation called a hybrid join. The
HBJOIN node is the defining node for a hybrid join construct. Only
inner joins can use a hybrid join.