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 | Reference |
|---|---|
| Syntax and options for the EXPLAIN request modifier | EXPLAIN Request Modifier |
| Interpreting the output of the EXPLAIN request modifier for request types | EXPLAIN Request Modifier |