Command Line Switches
Table 42 describes the Teradata Visual Explain command line switches.
Switch |
Description |
ux |
To 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. Note: The Use X views (DBC and QCD) check box must be selected. |
unx |
To 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. Note: The Use X views (QCD only) check box must be cleared. |
uxq |
To 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. Note: The Use X views (QCD only) check box must be selected. |
v |
To specify expanded or compressed view mode for plan display. The default view mode is expanded. |
p |
To specify Open Online plans operation. |
ie |
To specify Insert and View Execution Plan operation. |
vc |
To specify Visual Compare of Execution Plans operation. |
tc |
To specify Textual Compare of Execution Plans operation. |
ec |
To specify Explain text differences of Execution Plans operation. |
rc |
To specify a range of queryID. |
bc |
To specify Bulk Compare of Execution Plans operation. |
f |
To specify a file name. |
l |
To specify CLIv2 connectivity. |
c |
To specify ODBC connectivity. |
am |
To connect to the server using a specific alternate logging mechanism. |
d |
To specify the QCD database name. |
m |
To specify output in multiple files. It is used in bulk compare. |
t |
To specify Query Tag. It is used in Insert and View Execution Plan operation to specify query tag while inserting the execution plan. |
q |
To specify query text. It is used in case of Insert and View Execution Plan. |
db |
To 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 |
To specify Insert Explain in XML and View Execution Plan captured in XML format in QCD. Note: Only available for Teradata Database version 13.10 and later. |
xml |
To view execution plan captured in xml format in QCD. Note: Only available for Teradata Database version 13.10 and later. |
eix |
To view execution plan generated from database using Explain In XML command. |