Chat now with support
Chat with Support

SQL Optimizer for DB2 ZOS 5.6.1 - User Guide

Welcome Optimize SQL Options Tutorial About us Third-party contributions Copyright

Fill Missing Execution Plans

Note: This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.

To fill a missing execution plan

  1. Select the Optimize SQL tab.

  2. Enter a SQL statement in the Alternative Details pane.

  3. Click the arrow beside and select Fill Missing Plans.

  

Related Topics

Get Execution Plans

Copy Execution Plans

To copy an execution plan

Right-click the execution plan and select Copy.

Note: You can paste execution plans displayed as a Tree Plan or Plain Language Plan in text or bitmap format. Applications such as Microsoft Word allow you to choose the format using the Paste Special option. You can use text applications such as Notepad to paste execution plans in text format or graphic applications such as MS Paint to paste execution plans in bitmap format.

 

Related Topics

Fill Missing Execution Plans

Get Execution Plans

Generate Execution Plan Alternatives

Plan Control sessions optimize your SQL statement by generating execution plan alternatives for the statement. You can then select an alternative execution plan for your SQL statement and deploy it as a plan guide to improve database performance.

Note: This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.

To generate execution plan alternatives

  1. Select the Optimize SQL tab in the main window.

  2. Select Plan Control from the Optimize SQL start page.

    Note: If the start page does not display, click the arrow beside and select New Plan Control Session.

  3. Enter a SQL statement in the Original SQL pane.

  4. Click to retrieve the execution plan for your SQL statement. The Select Connection window displays.
  5. Select a connection.
  6. Click to generate execution plan alternatives.

  

Related Topics

Execute Execution Plan Alternatives

Compare Execution Plan Alternatives

Use the Compare window to view the SQL text, execution plan, and execution statistics for your original SQL statement and all alternatives SQL Optimizer generated. The Compare window consists of the Alternatives window and the Comparison window. The Alternatives window displays execution statistics and the Comparison window displays SQL statements and execution plans. You can compare your original SQL statement with an alternative SQL Optimizer generated or compare two different alternatives.

Note: This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.

To compare SQL statements

  1. Select the SQL Details tab in the main window.
  2. Click .

  3. Select an alternative in the Alternatives window to compare the statement with your original SQL statement.

    Note: The Comparison window displays the SQL text and execution plan for the original SQL statement in both panes by default.

    Tip: The alternative you selected is shown under your original SQL statement in the Alternatives window by default. To unfreeze the alternative selected, right-click the alternative and select Unfreeze Comparing Rows.

  4. Click to switch the location of the original SQL statement and selected alternative in the Comparison window.

    Note: Change the location of the original SQL statement to compare two alternative statements. Once you select the first alternative, click and select the second alternative.

  5. Click the current layout option in the Comparison Window to change the layout for the statements you are comparing. Review the following for additional information:

    SQL and Plan (Left-Right) Displays the SQL text and execution plan for the statements you are comparing side by side.
    Plan Only (Left-Right) Displays the execution plan for the statements you are comparing side by side.
    SQL and Plan (Top-Bottom) Displays the SQL text and execution plan for the statements you are comparing beneath each other.
    Plan Only (Top-Bottom) Displays the execution plan for the statements you are comparing beneath each other.

    Tips:

    • Click to maximize the comparison window.

    • Click to restore the comparison window to its original size.

  

Related Topics 

Related Documents