Adaptive Server provides
four primary JOIN operator
strategies: NESTED LOOP JOIN, MERGE
JOIN, HASH JOIN,
and NARY NESTED LOOP JOIN, which
is a variant of NESTED LOOP JOIN.
In versions earlier than 15.0, NESTED LOOP JOIN was
the primary JOIN strategy. MERGE
JOIN was also available, but was, by default,
not enabled.
Each JOIN operator
is described in further detail below, including a general description
of the each algorithm. These descriptions give a high-level overview
of the processing required for each JOIN strategy.
