Hash join requests
The HSJOIN join request element can be used to specify that the optimizer is to join two tables using a hash 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 hashJoinType.
XML Schema <xs:complexType name="hashJoinType"> <xs:complexContent> <xs:extension base="joinType"/> </xs:complexContent> </xs:complexType>
The complex type hashJoinType is a simple extension of the abstract type joinType. No new elements or attributes are added. If the hash 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> <HSJOIN> <ACCESS TABLE='S1'/> <IXSCAN TABLE='PS1'/> </HSJOIN> </OPTGUIDELINES>