Conclusion
Physical query processing consists of two fundamental steps: query compilation and query execution. The main link between the two steps is the query plan. Understanding how SQL Server generates the query plans and how it is using the plans to deliver the query result is vital for application developers, database designers, and administrators. Constructive use of the knowledge of how SQL Server performs its physical query processing might improve the database server’s performance and the application’s response time and throughput.
Acknowledgment
I received great help from several colleagues at Microsoft while I was working on this chapter. Mike Blaszczak, Alexis Boukouvalas, Milind Joshi, Stefano Stefani, Don Vilen, Umachandar Jayachandran, ...
Get Inside Microsoft® SQL Server™ 2005: T-SQL Querying 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.
