You can compare the current performance data with a saved
set of performance data or with a set that you imported.
Procedure
To compare the current performance data with another data
set:
- Select the Compare check box. If you are currently viewing a saved performance data set when
you click the Compare check box, the SQL Outline
view reverts to showing the current performance data set.
- In the field to the right of the Compare check
box, select the set of performance data that you want to compare with
the other set. This data set can be one that you saved
yourself or one that you imported.
Results
The SQL Outline view displays only those SQL statements
that exist in both data sets. If an SQL statement exists only in the
current data set or the set that you are using for comparison, the
SQL Outline does not show it.
Each of the columns shows the
data split into two halves. The left half, which is gray, shows the
data from the current performance data set. The right half shows the
data from the data set with which you are making the comparison.
Use
the Show field to choose how to display the
comparison of the data in the sets. These are the choices:
- Value
- In each column, the result from the first data set appears on
the left. The result from the second data set appears on the right.
- Difference
- In each column, the result from the first data set appears on
the left. The value that appears on the right in each column is A-B,
where A is the result from the first data set and B is the result
from the second data set.
- Percentage
- In each column, the result from the first data set appears on
the left. The value that appears on the right in each column is (A-B)/A,
where A is the result from the first data set and B is the result
from the second data set.
If you want to sort the results, click
to view the results in a table.
Then, select the Sort by check box and click
the headings for the columns by which you want to sort the data. The
values that appear on the right in the selected columns are sorted.