SQL Optimizer provides a variety of formats for displaying an execution plan. After selecting a plan format, you can customize the plan display and the Execution Plan window.
To select a plan format
Select a SQL statement.
Select one of the following formats:
To use the Tree Plan
Right-click an execution plan and select View Plan | As Tree Plan.
Select a layout style for the tree plan from the Execution Plan toolbar (right panel). Each style displays different plan details (operators, predicates, statistics).
To select which items/columns to display in the execution plan, right-click the plan and select Plan Options. The settings will apply to the current module only.
In the Actual Plan tab, to display a comparison of Oracle estimates and actual statistics, click the Plan Comparison button in the Execution Plan toolbar.
To use DBMS_XPlan
To select a display level for DBMS_XPlan (Formatted), click the arrow beside the Switch DBMS_XPlan level button and select an option.
To use the Plain Language Plan
Right-click an execution plan and select View Plan | As Plain Language Plan.
To use Graphic Plan
Right-click an execution plan and select View Plan | As Graphic Plan.
To use MS Graphic Plan
Right-click an execution plan and select View Plan | As MS Graphic Plan.
To return to previous view
To return to your previous view, click the Switch View Plan button at the bottom of the Execution Plan toolbar. Use this button to easily toggle between two views. Click the arrow to select a different view.
To customize font style and color
To display step description in footer
To display additional plan information
You can animate each step in the execution plan in the order SQL Optimizer executes them.
To animate the execution plan or cancel the animation
|»||Right-click the execution plan and select Animate Plan Steps.|
You can copy an execution plan from the Execution Plan pane and paste it into another file as text or a bitmap image.
To copy an execution plan
You can create an import file from SQL statements extracted by Scan SQL for import into Benchmark Factory if it is installed on the client computer.
Note: This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.
To create an import file
Select the checkboxes for the jobs you want to include in the Job List pane.
Note: This is only required if you want to include more than one job but not all jobs in the group.
Right-click a job and select Create Benchmark Factory Import File | option.