Viewing Execution Plans
This view presents the execution plan of a selected SQL and the cost of it. A Historical execution plan can be generated and will present any two views of the execution plan.
There are two ways to access the Execution Plan History dialog:
• From a Change Tracking pane by clicking on a row that displays Execution Plan change.
• From History by selecting the SQL statement from the Instance View or batch and by clicking Analyze Plan in the top of the table.
The execution plan dashboard displays the following content.
Top Bar
Resolving Date — Displays all the execution date and time of the selected statement.
Type — Displays the type of the execution plan.
Plan Hash Value — Displays the plan hash value of the execution plan
Plan analysis section
The execution plan is contains 3 tabs:
• Plan details — Displays details of each operation in the execution plan.
• Operation Analysis — Displays statistics aggregated per each operation in the execution plan.
• Object Analysis - Displays statistics aggregated per each object in the execution plan. Each object is clickable and displays a popup with important performance-related information.
By clicking the Generate Plan button the execution plan is generated and can be viewed. By clicking on the Compare Plan button a pop up will appear that allows comparing all available execution plans of the selected SQL statement.