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