How to specify a join algorithm In Joins, select the appropriate join and choose one of the following from the Specify join algorithm drop-down list shown in Figure 3-23: Dependent Merge Nested loop Figure 3-23 Specifying the join algorithm