Chat now with support
Chat mit Support

SQL Optimizer for DB2 ZOS 5.5.1 - User Guide

Welcome Optimize SQL Options Tutorial About us Copyright

View Optimization Details

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

To view optimization details

  1. Select the SQL Details tab in the main window.
  2. In the Alternatives pane, click .
  3. Select the SQL Information tab in the Optimize SQL window. Review the following for additional information:

    Optimization Details Description

    Intelligence level

    Intelligence level used for optimization. This option is set on the Optimizer Intelligence options page. Intelligence Options

    Semantically equivalent SQL statements

    Number of semantically equivalent SQL statements generated by SQL Optimizer.

    Alternative execution plans produced

    Number of alternative execution plans produced for the original SQL statement.

    SQL statements eliminated due to identical execution plans

    Number of statement alternatives eliminated with the same execution plan as the original SQL statement.

    Note: SQL statements with the same execution plan produce the same run time because the database executes these statements in the same way. Therefore, SQL Optimizer eliminates alternatives with equivalent execution plans.

    Optimization Time Details Description

    Optimization started at

    Time optimization started.

    Optimization finished at

    Time optimization finished.

    Total optimization time

    Total time to complete optimization.

    Average optimization time

    Average time to generate each statement alternative.

    Notes:

    • This information is only available after you generate SQL alternatives.
    • Optimization details only display for the original SQL statement.

 

View Schema Information

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

To view schema information

  1. Select the SQL Details tab in the main window.
  2. Select the Schema Information tab in the Optimize SQL window.

  3. Click beside the Summary list and select a table for additional information.

  

Related Topics  

View Bind Variables

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

To view bind variables

  1. Select the SQL Details tab in the main window.
  2. Select the Bind Variables tab in the Optimize SQL window.

The parameters for the bind variable defined for your SQL statement display. Set Bind Variables

Note: Information is only displayed in this tab if you used variables for optimization.

  

Related Topics 

View Schema Information

Show or Hide Table Attributes

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

To show or hide a table attribute

  1. Select the SQL Details tab in the main window.
  2. Select the Schema Information tab in the Optimize SQL window.

  3. Right-click the header row in the Summary Details pane and select Column Chooser.

  4. Add or remove table attributes by dragging the column names to and from the Customization dialog.

  

Related Topics

Show or Hide Column Attributes

Verwandte Dokumente

The document was helpful.

Bewertung auswählen

I easily found the information I needed.

Bewertung auswählen