Constrains the join algorithm choices available to the optimizer under certain circumstances.
1 to 4294967295
Can be set temporary, for a user or for the PUBLIC group. Takes effect immediately.
100000
This option allows you to control the minimum number of rows which must be present in a table (or a UNION ALL view of tables) before the join optimizer considers using either the hash push-down join (HPDJ) or the sort/merge push-down join (SMPDJ) algorithms. Under most circumstances you do not need to change the value of this option.
