Comparing Multiple Execution Plans Using Bulk Compare

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
Multiple execution plans can be compared using Bulk Compare, which can be invoked through the command line.
  • To compare multiple execution plans using Bulk Compare, use the following command:
    VEComp -bc <count of QCDs> [-m] <Online Plan description1 Online Plan
    description2
     [Online Plan description3...] > -f <output file name>
    Count of QCDs: Number of online plan descriptions involved in Bulk
    Compare.

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

Example Commands Comparing Multiple Execution Plans Using Bulk Compare

The following table describes the commands for comparing multiple execution plans using the Bulk Compare feature.

Examples for Comparing Multiple Execution Plans Using Bulk Compare 
Example Command Description
1
VEComp -bc 2 -m -l SysC\dbc\dbc
-d BulkComQcd1 -rc 1-20
-l SysA\dbc\dbc -d BulkComQcd2
-rc 10-30 -f BulkCompareOut.txt
Opens plans whose queryID is in the range 1–20 from database qcd 'BulkComQcd1' on server Teradata Database SysC, and whose queryID is in the range 10–30 from database qcd 'BulkComQcd2' on server Teradata Database SysA. It compares the information and saves the Bulk Compare output in multiples files.
2
VEComp -bc 2 -c SysC\dbc\dbc
-d BulkComQcd1 -rc 1-20
-c SysA\dbc\dbc -d BulkComQcd2
-rc 10-30 -f BulkCompareOut.txt
Opens plans whose queryID is in the range 1–20 from database qcd 'BulkComQcd1' on server Teradata Database SysC, and whose queryid range is 10–30 for database qcd 'BulkComQcd2' on server Teradata Database SysA. It compares the information and saves the Bulk Compare output in 'BulkCompareOut.txt' file.
3
VEComp -bc 2 -c SysC\dbc\dbc
-d qcd -rc 1-20 -c SysA\dbc\dbc
-d qcd -rc 10-30 -f
BulkCompareOut.txt
Opens plans whose queryID range is 1–20 from database qcd on server Teradata Database server SysC and whose queryID range is 10–30 from database qcd on server Teradata Database server SysA. It compares the information and saves the Bulk Compare output in 'BulkCompareOut.txt' file.