15.10 - Displaying a Textual EXPLAIN Plan - SQL Assistant

Teradata SQL Assistant for Microsoft Windows User Guide

prodname
SQL Assistant
vrm_release
15.10
category
User Guide
featnum
B035-2430-035K

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.