Join nodes

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.

Feedback