16.10 - Generating an EXPLAIN with BTEQ - Teradata Database

Teradata Database Administration

Product
Teradata Database
Release Number
16.10
Release Date
April 2018
Content Type
Administration
Publication ID
B035-1093-161K
Language
English (United States)

To generate an EXPLAIN for an SQL request, add the word “EXPLAIN” at the beginning of the request.

For example, the following SQL performs an EXPLAIN on a SELECT statement:

EXPLAIN SELECT * FROM Employee;

If you want a dynamic request plan instead, issue DYNAMIC EXPLAIN request. For example,

DYNAMIC EXPLAIN SELECT * FROM Employee;

Reference Information

Topic Resources for Further Information
Syntax and options for the EXPLAIN request modifier SQL Data Manipulation Language
Interpreting the output of the EXPLAIN request modifier for various request types SQL Request and Transaction Processing
Teradata Visual Explain utility Teradata Visual Explain User Guide