![]() ![]() If this does not occur until the end of query execution, the query will usually perform poorly. Join ordering is extremely important because if a join creates a huge interim result set at the beginning of the query execution, SQL Server must continue to handle this result set until it can be trimmed down with filtering or additional join clauses. Queries with multiple join clauses create particularly difficult issues when they perform poorly.
0 Comments
Leave a Reply. |