Comparing Steps in Execution Plans - Visual Explain

Teradata Visual Explain User Guide

Product
Visual Explain
Release Number
15.00
Language
English (United States)
Last Update
2018-09-27
dita:id
B035-2504
lifecycle
previous
Product Category
Teradata Tools and Utilities

Comparing Steps in Execution Plans

Use the Compare Steps feature to see the differences in particular steps of two or more execution plans. Unlike the visual and textual comparisons, the Compare Steps feature includes the ability to compare different steps between plans.

To use the Compare Steps feature

Load two or more execution plans before using the Compare Steps feature.

1 Click .

The Select Steps for Compare dialog box appears.

Figure 34: Select Steps for Compare

2 Double-click on a step in the left column to use as the basis for the comparison.

The step is moved to the top of the column, highlighted in green, and annotated as “Base Step.”

3 In the right column, click on the steps to compare to the selected base step.

All selected steps are moved to the top of the column, highlighted in green, and annotated as “Compare Step.”

4 [Optional] To remove all base and compare steps that are highlighted in green, click Clear All.

5 Click Compare.

The Step Compare Information window appears, and the differences between the base step and the compared steps are highlighted in red.

Figure 35: Step Compare Information

6 Do one of the following:

  • Click OK to return to the Select Steps for Compare dialog box and perform another comparison.
  • Click Cancel to close the comparison and return to the Select Steps for Compare dialog box.