Query Development | Explain and Dynamic Explain | Teradata Studio/Studio Express - Explain and Dynamic Explain - Teradata Studio

Teradata® Studio™ Express User Guide - 17.20

Product
Teradata Studio
Release Number
17.20
Published
September 2022
Language
English (United States)
Last Update
2022-09-23
dita:mapPath
ztp1648839236373.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2042
Product Category
Teradata Tools and Utilities

The Explain command displays the step-by-step translation of the query plan used in executing the SQL query in the SQL editor. The Dynamic Explain command displays the step-by-step plan of a query that uses IPE (incremental planning and execution).

After executing a query in the SQL Editor, you can view the Explain or Dynamic Explain steps in the Result Set Viewer. You can also view the results by selecting either of those commands from the SQL menu or by pressing F6 for Explain or F7 for Dynamic Explain. The outline view displays an outline of the Explain or Dynamic Explain SQL statement in the editor area and lists the steps in a structured format.