Best Practices for Managing Joins

In most cases, the sequence in which joins are specified on the Joins tab does not matter. However, it is possible that the query optimizer for the data source performs the joins in a sequence that reduces performance. In these rare cases, you can change the sequence of the joins on the Joins tab by selecting the join in the list and clicking or . This join sequence is still determined by the query optimizer, but you can control how the SQL for the join is presented to the query optimizer.