Command Line Switches

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

The following table describes the Teradata Visual Explain command line switches.

Command Line Switches 
Switch Description
ux Use DBC and QCD X views (on Teradata Database V2R6.0, V2R6.1, and V2R6.2) or DBC and QCD VX views (on Teradata Database 12.0 and later) while retrieving plans from a QCD.
The Use X views (DBC and QCD) check box must be selected.
unx Use DBC and QCD non-X views (on Teradata Database V2R6.0, V2R6.1, and V2R6.2) or DBC and QCD V views (on Teradata Database 12.0 and later) while retrieving plans from a QCD.
The Use X views (QCD only) check box must be cleared.
uxq Use only QCD X views (on Teradata Database V2R6.0, V2R6.1, and V2R6.2) or only QCD VX views (on Teradata Database 12.0 and later) while retrieving plans from the QCD.
The Use X views (QCD only) check box must be selected.
v Specify expanded or compressed view mode for plan display. The default view mode is expanded.
p Specify Open Online plans operation.
ie Specify Insert and View Execution Plan operation.
vc Specify Visual Compare of Execution Plans operation.
tc Specify Textual Compare of Execution Plans operation.
ec Specify Explain text differences of Execution Plans operation.
rc Specify a range of queryID.
bc Specify Bulk Compare of Execution Plans operation.
f Specify a file name.
l Specify CLIv2 connectivity.
c Specify ODBC connectivity.
am Connect to the server using a specific alternate logging mechanism.
d Specify the QCD database name.
m Specify output in multiple files. It is used in bulk compare.
t Specify Query Tag. It is used in Insert and View Execution Plan operation to specify query tag while inserting the execution plan.
q Specify query text. It is used in case of Insert and View Execution Plan.
db Specify the default database name in case of command line INSERT EXPLAIN. The database supplied is only effective in case of INSERT EXPLAIN command line.
a Used with textual compare to display all types of differences.
cs Used with textual compare to display cost differences only.
ic Used with textual compare to display index condition differences only.
jc Used with textual compare to display join condition differences only.
rsc Used with textual compare to display residual condition differences only.
jo Used with textual compare to display join order differences only.
op Used with textual compare to display operation differences only.
opd Used with textual compare to display operand differences only.
sc Used with textual compare to display Teradata Database configuration differences only.
scs To connect to the server using a specified session character set.
ta Used with textual compare to display target attribute differences only.
iex Specify Insert Explain in XML and View Execution Plan captured in XML format in QCD.
Only available for Teradata Database version 13.10 and later.
xml View execution plan captured in xml format in QCD.
Only available for Teradata Database version 13.10 and later.
eix View execution plan generated from database using Explain In XML command.