Generating an EXPLAIN with BTEQ
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
|
Information on... |
Is available in... |
|
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 |