Comparing current performance data with an older set of data

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:

  1. 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.
  2. 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 Show tree view or table view 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.


Feedback