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. 

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.