The Plan Viewer is a graphical tool for viewing graphical plans for Adaptive Server databases and text plans.
To start the Plan Viewer go to Tools | Plan Viewer (or press Shift+F5)2.The Plan Viewer window is divided into panes:
Details – Shows information such as per-node cost and partition information.
XML – Displays the plan in XML format.
Text – Displays the plan in straight text format. Similar to the showplan output.
Advanced – Displays more advanced details of the plan:
Plan Information – Plan version, statement number, line number, the abstract query plan.
Resource utilization – Threads, auxiliary session descriptors (SDESs).
Cost information – Logical I/O, physical I/O, CPU utilization, and so on.
Optimizer Metrics – Time, taken in milliseconds, first plan time, in milliseconds, plans evaluated, plans valid, procedure cache used.
Optimizer statistics for objects (tables, columns) – update statistics for the last run time, missing density and histogram information. You can fix many problems by running update statistics by selecting “Update Stats” for the missing density column of the table.