Reading Query Plans

Query Plan Option

1. Graphical Plans 
    
  Displayed estimated execution Plan   (ctrl+L)
  Include Actual execution Plan   (ctrl+M)
 
2. Text Plans

  SET SHOWPLAN_TEXT ON
  go
  go  SET SHOWPLAN_TEXT OFF


3. XML Plans

 SET SHOWPLAN_XML ON
  go
   Select * from tablename
  go
  SET SHOWPLAN_XML OFF

In order to view complete statistics


SET STATISTICS PROFILE ON

 In order to Execution Times

SET STATISTICS TIME ON




Query Optimizer
Query Execution Engin Select * from tablenameSET STATISTICS PROFILE OFF   Select * from tablename