You can compare the current performance data with a saved
set of performance data or with a set that you imported.
Before you begin
The performance metrics columns must be visible in the SQL
Outline view. Click the arrow on Show or Hide
Columns (
) and select Performance
Columns.
Procedure
To compare the current performance data with another
data set:
- At the top of the SQL Outline view,
select the type of performance data from Performance Data
Type.
- Select the Compare check box.
If you are currently viewing a saved Workbench SQL 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
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.