Constrains the join algorithm choices available to the optimizer under certain circumstances.
1 – 4294967295
25000
Can be set temporary, for a user or for the PUBLIC group. Takes effect immediately.
MIN_SMPDJ_OR_HPDJ_FILTERED_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 no joins or only lookup 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.
