Performance perspective
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:
- SQL-tab
- Indexes-tab
- Explain-tab
- Cost-tab
- Predicates-tab
- Compare-tab (available in the Classic console only)
- Related-Objects-tab (available in the Classic console only)
- Output tab/Results tab
# | Description |
|---|---|
1 | Tuning session pane |
2 | Buttons for adding SQL statement 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 dimmed after the statement is successfully explained. |
6 | What-If button The What-If button is 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 box. |
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 time stamp and Db2 subsystem name |
13 | Options button |
14 | Migrate statistics button This button opens the Migrate statistics dialog box. |
15 | |
16 | Show graph view button These buttons switch the display between graph view and tree view. |
17 | Full screen button These buttons switch the display between full screen view and standard screen view. |
and removing 
views
or 
or Close button 
# | Description |
|---|---|
1 | Tuning session pane |
2 | Buttons for adding SQL statement 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
|
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
|
and removing 
views
indicates that at least one attribute of an object has different values in the two statements being compared.
This section provides more information about the following topics: