Generating an EXPLAIN with BTEQ - Teradata Database - Teradata Vantage NewSQL Engine

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