Query Processing Architecture
The Database Engine processes queries on a variety of data storage architectures such as local tables, partitioned tables, and tables distributed across multiple servers. The following topics cover how SQL Server processes queries and optimizes query reuse through execution plan caching.
In This Section
SQL Statement Processing
Contains topics about processing SELECT statements that reference local tables.Stored Procedure and Trigger Execution
Describes executing stored procedures and triggers.Execution Plan Caching and Reuse
Contains topics about caching and reusing query execution plans.Parallel Query Processing
Contains topics about creating and executing parallel query execution plans.Distributed Query Architecture
Describes executing queries on data that is distributed across multiple servers.Query Processing Enhancements on Partitioned Tables and Indexes
Describes enhancements in SQL Server 2008 for executing queries on partitioned tables and indexes.