Nested-loop join requests
The NLJOIN join request element can be used to specify that the optimizer is to join two tables using a nested-loop join method.
Either table can be local or derived, as specified by an access request sub-element, or it can be the result of a join operation, as specified by a join request sub-element. A derived table is the result of another subselect. This join request element is defined by the complex type nestedLoopJoinType.
XML Schema <xs:complexType name="nestedLoopJoinType"> <xs:complexContent> <xs:extension base="joinType"/> </xs:complexContent> </xs:complexType>
The complex type nestedLoopJoinType is a simple extension of the abstract type joinType. No new elements or attributes are added. If the nested-loop join method is not in the search space that is in effect for the statement, the join request is ignored and SQL0437W with reason code 13 is returned.
<OPTGUIDELINES> <NLJOIN> <IXSCAN TABLE='"Samp".Parts'/> <IXSCAN TABLE="PS"/> </NLJOIN> </OPTGUIDELINES>