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;
Related 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 | SQL Request and Transaction Processing, B035-1142 |