Comparing statements

Use the following procedure to compare Explain results within the same tuning session.

Before you begin

Create one or more What-If statements, as instructed in Creating-a-What-If-scenario.

Note

The Compare function is not available until you create at least one What-If scenario.

New console

In the Performance perspective, click to open the Compare dialog.
In the Compare dialog, from the statement list on the left, select the first statement for comparison.
From the statement list in the comparison dialog on the right, select a second statement for comparison.
Note
The selected What-If statement is initially displayed in the comparison dialog on the right, and the Performance perspective's tabs show information about that statement.
Click any step node of the Explain trees to compare the attributes of the selected node.The results pane shows detailed information for the selected nodes in the trees.
Explain trees of both statements are displayed side-by-side, and in the results pane, a table compares attributes of the two statements. In each row, the first column displays the attribute name, the second column displays the value of the node in the first statement (left tree), and the third column shows the value of the second statement (right tree).
Note
indicates that the attribute has different values in the two statements being compared.

Classic console

In the Performance perspective, open the Compare tab.
From the tuning session pane, in the comparison pane on the left, select the first statement for comparison.
Note
The first statement is always displayed in the comparison panel on the left, and the Performance perspective's tabs show information about that statement.
From the list in the comparison pane on the right, select a second statement for comparison.
Click any step node of the Explain tree to compare the attributes of the selected node.The results pane shows detailed information for the selected nodes in the trees.
Explain trees of both statements are displayed side-by-side, and in the results pane, a table compares attributes of the two statements. In each row, the first column displays the attribute name, the second column displays the value of the node in the first statement (left tree), and the third column shows the value of the second statement (right tree).
Note
indicates that the attribute has different values in the two statements being compared.