Chapter 3. Query Execution
—Craig Freedman
| In this chapter: | |
| Query Processing and Execution Overview | 103 |
| Reading Query Plans | 107 |
| Analyzing Plans | 115 |
| Summary | 198 |
The SQL Server query processor consists of two components: the query optimizer and the query execution engine. The query optimizer is responsible for generating good query plans. The query execution engine takes the query plans generated by the query optimizer and, as its name suggests, runs them. Query execution involves many functions, including using the storage engine to retrieve and update data from tables and indexes and implementing operations such as joins and aggregation.
The focus of this chapter is on understanding query behavior by examining the details of your query execution ...
Get Inside Microsoft® SQL Server™ 2005: Query Tuning and Optimization now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
