IBM Books

MSJOIN

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

Join predicates
The join predicates upon which the join is performed.

Outer order columns
The ordering columns of the outer stream.

Inner order columns
The ordering columns of the inner stream.

Residual predicates
The set of additional predicates to be applied as residuals.

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 MSJOIN operator is performing:

[ Top of Page | Table of Contents | Glossary | Index ]

[ DB2 List of Books | Search the DB2 Books ]