Execution Plan in Sql Server

Execution Plan is the list of steps that Sql will follow in order to executed a  SQL setement. 

Each step is one of the finite number of basic operations know to database server

• Step 0 is select statement.
• Step 1 is table access by index row ID 
• Step 2 is index range scan.

 

That means that these are the 3 steps which Sql understands in this execution plan. It is saying fast 

• I will do index range scan using the index ‘SALE_ORD_IDX’ And once I find the row ID I will get that through. 
• And once I find the row ID I will pass that row id to the operation ‘TABLE ACCCESS BY INDEX ROWID’
• once it get the rowid, it goes to that particular row get its values and give to next operation ‘SELECT STATEMENT’

 

So execution plan is a list of steps, Sql will follow to execute these sql statement.