Specifies the minimum number of rows that must be present in a table before the join optimizer considers using the nested-loop push-down join (NLPD) algorithm.
1 – 4294967295
10000
Can be set temporary, for a user or for the PUBLIC group. Takes effect immediately.
This option allows you to control the minimum number of rows in a table before the join optimizer considers using the nested-loop push-down join algorithm. Under most circumstances, you do not need to change the value of this option.
