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

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