Execution Plan in Sql Server for Indexes

 

• Lets check the Execution Plan without create any Index
  • 

 

 

• This clearly show here that it's doing a table scan because it does not have an index.
  • 
  • it's giving a recommendation to make a non-clustered index not only on the first name, but also other things.

 

• Create Index from Execution plan itself
  • Right non recommendation and click 
  • 
  •  
• On clicking the option this give me following recommendation
  • 
  • I used the following Query
  • 

 

• Run Execution Plan again
  •