Terms Used in Visual Explain

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 terms used in the command line feature.

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 }
}
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] }