HSJOIN

For the HSJOIN operator, the following input arguments are shown:

Early out

A flag that is true if only one inner row matching outer row is needed ("early out").

Outer join type

A flag indicating which type of outer join this NLJOIN operator is performing:

Join predicates

The join predicates upon which the join is performed.

Bit filter

A flag that is true if a bit filter is used to enhance hash join performance.