Articles → SQL SERVER → Introduction To Execution Plans

Introduction To Execution Plans






Components




  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

Click to Enlarge


Process




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

    Click to Enlarge





Query Parsing





Algebrizer




  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

Query/Feedback


Your Email Id  
 
Subject 
 
Query/FeedbackCharacters remaining 250