Displaying a Textual EXPLAIN Plan - SQL Assistant

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.

Do one of the following:

Select Tools > Explain.

Press F6.

The explanation appears in the Answerset window.

Example  

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.