Constrains the join algorithm choices available to the optimizer under certain circumstances.
1 – 4294967295
500000
Can be set temporary, for a user or for the PUBLIC group. Takes effect immediately.
MIN_SMPDJ_OR_HPDJ_INDIRECT_SIZE allows you to control the minimum number of rows a table (or a UNION ALL view of tables) must have left after the filtering effects of all local predicates have been considered before the join optimizer considers using either the hash push-down join (HPDJ) or the sort-merge push-down join (SMPDJ) algorithms for situations where there are nonlookup (many-to-many or many-to-1) joins between this join and the table (or the UNION ALL view). Under most circumstances, you do not need to change the value of this option.
