The Plan table displays information about all execution plans found for the selected SQL statement. The information covers all plans and all the steps with each plan.
To open the Plan page
Click SQL & Application Workload | Analyze Trace | Trace Files.
Plan Grid
You can view the grid as a tree or flat table. Tree View
Note: Not all columns are visible by default. Use the Column Organizer to view hidden columns. Show, Hide & Order Columns
Column | Description |
---|---|
Plan |
Each row in the table represents an execution plan or plan step found for the SQL statement displayed in SQL Text above. |
Act Rows |
The number of rows returned by a plan step that are either used by the next step in the plan, OR that are returned to the user or application that submitted the SQL statement for processing. |
Logical Reads |
The total number of logical reads performed for the specified plan or plan step. |
Physical Reads |
The total number of physical reads performed for the plan or plan step. |
Time (ms) |
The total elapsed time spent executing the plan or plan step. The time taken includes the time taken to execute any child steps. |
Exec Count |
The number of times the plan or plan step was executed. |
ID |
A unique identifier for the current step. |
PID |
The ID of the step that is the parent of the current step. The output of the current step is fed into its parent step for processing. |
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback 이용 약관 개인정보 보호정책 Cookie Preference Center