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.