Command Line Switches - Visual Explain

Teradata Visual Explain User Guide

Product
Visual Explain
Release Number
15.00
Language
English (United States)
Last Update
2018-09-27
dita:id
B035-2504
lifecycle
previous
Product Category
Teradata Tools and Utilities

Command Line Switches

Table 42 describes the Teradata Visual Explain command line switches.

 

Table 42: 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.