2 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…
