Comparing Steps in Execution Plans - Visual Explain

Teradata Visual Explain User Guide

Product
Visual Explain
Release Number
16.20
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-05-04
dita:mapPath
pvi1488824663157.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2504
Product Category
Teradata Tools and Utilities

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.