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.
| 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. |