Terms Used in Visual Explain - Visual Explain

Teradata Visual Explain User Guide

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

Table 43 describes the terms used in the command line feature.

 

Table 43: Terms and Syntax 

Term

Syntax

Execution Plan

{

{ Online Plan description} ||

{ -f <Offline Execution Plan file name>}

}

Online Plan Description

{ <Logon Specification>
-d <database name>
{-rc <Range condition> || -t <query tag> }

{ -ux || -unx }

}

Online XML Plan Description

{ <Logon Specification>

-d <database name>

-xml

{-rc <Range condition>}

{ -ux || -unx }

}

Note: Only available for Teradata Database version 13.10 and later.

Logon Specification

{ { -l <Server Name>\<User Id>\<Password>

[-am<Authentication Mechanism>\<Authentication Parameter>]

[-scs<Session Character Set Name>]}

|| { -c <ODBC DSN Name\password>

[-am[<Authentication Mechanism>\]<Authentication Parameter>]

[-scs<Session Character Set Name>]}

}

Range Condition

{QueryId1 [{, || -} QueryId2….]}

Query Tag

{-t <querytag>}

Compare attribute

{ { -a } || {-cs} || {-sc} || {-jo} || {-jc} || {-ta} ||
{-op} || {-opd} || {-rsc}

}

View Mode

{ [-v expanded || -v compressed] }