When you execute a query, SQL Server has to decide things like: Which table to process first Which index to use on that table How to access that index (seek vs scan) How many rows it will find that match your search predicates And the more tables you have in the query, the more complex…
1 Building a Query Plan
When you execute a query, SQL Server has to decide things like: Which table to process first Which index to use on that table How to access that index (seek vs scan) How many rows it will find that match your search predicates And the more tables you have in the query, the more complex...
To access this incredible, amazing content, you gotta get Fundamentals of Query Tuning or Recorded Class Season Pass, or log in if you already shelled out the cash.