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 |