Displaying a Textual EXPLAIN Plan
You can run an Explain function on the SQL statements in the Query window and display the results in the Answerset window. Teradata SQL Assistant displays the steps that would be executed if you were to actually run the query.
The explanation appears in the Answerset window.
The explanation below is returned for the following statement:
sel * from dbc.sessioninfo
1 Select Tools > Options.
2 Select the Query tab
3 Select the option Submit only the selected Query text, when highlighted.
4 Highlight part of a query that you want explained (the highlighted portion must be a valid SQL statement).
5 Select Tools > Explain.
The query explanation appears in the Answerset window.