How to specify a join algorithm In Joins, select the appropriate join. In Specify join algorithm, shown in Figure 2-9, choose one of the following join algorithms: Dependent Merge Nested loop Figure 2-9 Specifying a join algorithm