Execution plan

Concept

The plan a SQL query optimizer chooses to execute a query, including access methods, join algorithms and sorts; estimated plans show the optimizer's intent and actual plans add runtime details.

Title graphic: Execution plan (Concept)

Type	Concept
Documentation	learn.microsoft.com/en-us/sql/relational-databases/performance/execution-plans?view=sql-server-ver17

Articles about Execution plan (2)

Beyond MRP: Why Enterprise Resource Planning Fails at Finite Production Scheduling
2026-09-16 · Mirko Peters
Discover why traditional MRP and ERP systems cannot create a realistic, executable production schedule due to the infinite-capacity planning assumption.
Fabric Performance Tuning: Strategies for Optimal Workloads
2026-02-11 · Mirko Peters
When you start working with Microsoft Fabric, performance tuning isn’t just a nice extra—it’s the key to making those data workloads hum. This pie…

Glossary

Community wiki

Short info above, community knowledge below: add practical tips, examples or corrections. New contributions are reviewed first; trusted members publish directly.

Experts and companies for this topic

Nobody has listed this topic yet. Add it to your profile.

Sources

Documentation: learn.microsoft.com/en-us/sql/relational-databases/performance/execution-plans?view=sql-server-ver17
Feed for this topic (RSS): entity/execution-plan/feed.xml
Articles on this topic: 2

Maintained by Mirko Peters (Microsoft MVP) · Last updated: 2026-11-03