Microsoft SQL Server 2012 Internals

Conclusion

This chapter explained the basics of query processing in SQL Server. It introduced iterators—the fundamental building blocks of query processing—and discussed how to view query plans in three different formats: text, graphical, and XML. You learned about many of the most common iterators, including the iterators that implement scans and seeks, joins, and aggregation. You looked at more complex query plans including dynamic index seeks, index unions and intersection, and various subquery examples. You also explored how the query processor implements parallel query execution. All the query plans that SQL Server supports are built from these and other basic operators. The chapter closed with a section explaining data warehousing, optimized ...