Displaying Differences in Explain Text of 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
Explain text differences of execution plans can be accessed through the command line.
  • To display Explain text differences, use the following command:
    VEComp -ec <Execution Plan1 [Execution Plan2...]>

    The first plan specified in the command is the base plan for comparison.

Example Commands for Explain Text of Execution Plans

The following table describes the commands for displaying differences using Explain text.

Examples for Displaying Differences in Explain Text 
Example Command Description
1
VEComp -ec -l sysB\dbc\dbc
-d qcd -rc 73-78 -l sysA\dbc\dbc
-d qcd -rc 75-80
Opens plans whose queryID is in the range 73–78 from database qcd on server sysB, and whose queryID is in the range 75–80 from database qcd on server sysA using CLIv2 connectivity.
2
VEComp -ec -l sysB\dbc\dbc
-d qcd -rc 73 -l sysA\dbc\dbc
-d qcd -rc 75
Opens plans whose queryID is 73 from database qcd on server sysB, and whose queryID is 75 from database qcd on server sysA using CLIv2 connectivity.
3
VEComp -ec -l sysB\dbc\dbc
-d qcd -rc 73-78
Open plans whose queryID is in the range 73–78 from database qcd on server sysB, using CLIv2 connectivity.
4
VEComp -ec -l sysB\dbc\dbc
-d qcd -rc 73
-f validVECFile.vec
Open plans whose queryID is 73 from database qcd on Server sysB, and that is from a valid VECFile.vec.
5
VEComp -ec -f ValidVECfile1.vec
-f ValidVECfile2.vec
Opens execution plans from files ValidVECfile1, ValidVECfile2.vec.