Query Processing and Execution Overview
To better understand the factors that affect query performance, to understand how to spot potential performance problems with a query plan, and ultimately to learn how to use query optimizer hints to tune individual query plans, we first need to understand how the SQL Server query processor executes queries. In this section, we introduce iterators, one of the most fundamental query execution concepts, discuss how to read and understand query plans, explore some of the most common query execution operators, and learn how SQL Server combines these operators to execute even the most complex queries.
Iterators
SQL Server breaks queries down into a set of fundamental building blocks that we call operators ...
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.
