Join Order

The order in which the database server joins tables in a query is important for performance. The optimizer usually selects the optimal join order, basing its choice on data distributions created by UPDATE STATISTICS. However, sometimes the optimizer cannot evaluate a complex expression, and might make the wrong assumptions. The result of a subquery might be particularly difficult to evaluate.