Articles → SQL SERVER → Introduction To Execution Plans

Introduction To Execution Plans


  1. Relational engine – This component generates an execution plan from the query submitted by the query source
  2. Storage engine – Executes query based on the execution plan

Picture showing the pictorical representation of the process from query submission to query execution


  1. Query parsing
  2. Algebrizer
  3. Query optimizer
  4. Picture showing the pictorical representation of the different processes in the relational database

Query Parsing


  1. It resolves the names of tables and columns mentioned in the query
  2. It identifies data type associated with each column of the table
  3. It also identifies the aggregate functions i.e. group by, max etc. mentioned in the query

Query Optimizer

Estimated And Actual Execution Plan

Posted By  -  Karan Gupta
Posted On  -  Wednesday, April 1, 2015


Your Email Id  
Query/FeedbackCharacters remaining 250