Comparing Steps in Execution Plans

Teradata Visual Explain User Guide

brand
Teradata Tools and Utilities
prodname
Visual Explain
vrm_release
16.10
16.20
category
User Guide
featnum
B035-2504-086K

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.

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

  1. Click .

    The Select Steps for Compare dialog box appears.

    Select Steps to Compare

  2. Double-click 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 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.

    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.