Space announcement

   

This space provides the same content as before, but the organization of the home page has changed. The content is now organized based on logical branches instead of legacy book titles. We hope that the new structure will help you quickly find the content that you need.

Performance perspective

The commands in the Performance perspective enable you to analyze SQL statements, perform What-If comparisons, and migrate access path statistics for an object.

Selecting a SQL statement for analysis (see Selecting a statement for SQL Analysis) displays the Performance perspective.

The Performance perspective provides access to the result view tabs, which enable you to perform the tuning process. Depending on the activities being performed, the following tabs can be displayed:

    #

    Description

    1

    Tuning session pane

    2

    Buttons for adding SQL statement views and removing views

    3

    Active workspace name

    An asterisk (*) indicates that the workspace has unsaved changes.

    4

    Perspective tabs

    The Performance tab is underlined with orange, indicating that it is the active tab.

    5

    Generate Explain plan button

    The button is disabled (dimmed) after the statement is successfully explained.

    6

    What-If button

    The What-If button is disabled (dimmed) on a selected statement if the statement has not been successfully explained. Unless the statement is successfully explained, you cannot create a What-If scenario based on that statement.

    7

    Compare button

    This button opens the Compare dialog.

    8 Name and ID of the active statement

    9

    Run button

    This button executes the statement on the SQL tab and displays the output on the Results tab.

    10

    Explain tree of the SQL statement

    11

    Result view tabs that show the result of explaining a statement, and catalog objects

    12

    Explain timestamp and DB2 subsystem name

    13

    Options button


    #

    Description

    1

    Tuning session pane

    2

    Buttons for adding SQL statement views and removing views

    3

    Active workspace name

    An asterisk (*) indicates that the workspace has unsaved changes.

    4

    Perspective tabs

    The Performance tab is blue, indicating that it is the active tab.

    5

    Generate Explain plan button

    The button is dimmed after the statement is successfully explained.

    6

    What-If button

    The What-If button is disabled (dimmed) on a selected statement if the statement has not been successfully explained. Unless the statement is successfully explained, you cannot create a What-If scenario based on that statement.

    7

    Run button

    8

    Migrate statistics button

    This button lets you migrate access path statistics for one or more objects.

    9

    Name and ID of the active statement

    10

    (Compare tab only) Explain tree of the first statement

    Note

    indicates that at least one attribute of an object has different values in the two statements being compared.

    11

    The Result view tabs that show the result of explaining a statement, a compare, and catalog objects.

    12

    (Compare tab only) Explain tree of the second statement

    13

    Explain timestamp and DB2 subsystem name

    14

    Options button

    15

    (Compare tab only) Attribute details of the second statement

    16

    (Compare tab only) Attribute details of the first statement

    17

    (Compare tab only) Attribute names

    Note

    indicates that the attribute has different values in the two statements being compared.

     This section provides more information about the following topics:

    Related topic

    Was this page helpful? Yes No Submitting... Thank you

    Comments