Generate an EXPLAIN with BTEQ | Teradata Vantage - 17.00 - 17.05 - Generating an EXPLAIN with BTEQ - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Database Administration

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
17.05
Published
June 2020
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
rgu1556127906220.ditamap
dita:ditavalPath
lze1555437562152.ditaval

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 Teradata Vantage™ - SQL Data Manipulation Language, B035-1146
Interpreting the output of the EXPLAIN request modifier for various request types Teradata Vantage™ - SQL Request and Transaction Processing, B035-1142
Teradata Visual Explain utility Teradata® Visual Explain User Guide, B035-2504