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
| Topic | Resources for Further Information |
|---|---|
| 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 |