Chapter 35. Understanding Query Optimization
by Ray Rankins
IN THIS CHAPTER
What Is a Query Optimizer?
Query Compilation and Optimization
Step 1: Query Analysis
Step 2: Index Selection
Step 3: Join Selection
Step 4: Execution Plan Selection
Reusing Query Plans
Other Query Processing Strategies
Parallel Query Processing
Data Warehousing and Large Database Query Strategies
Common Query Optimization Problems
Managing the Optimizer
Query optimization is the process SQL Server goes through to analyze individual queries and determine the best way to process them. To achieve this end, SQL Server uses a cost-based optimizer. As a cost-based optimizer, the optimizer's purpose is to determine the query plan that will access the data with the least amount of processing ...