Displaying a Textual EXPLAIN Plan - SQL Assistant

Teradata SQL Assistant for Microsoft Windows User Guide

Product
SQL Assistant
Release Number
15.00
Language
English (United States)
Last Update
2018-09-27
dita:id
B035-2430
lifecycle
previous
Product Category
Teradata Tools and Utilities

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.

To issue a Textual EXPLAIN for a whole 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

    To issue a Textual EXPLAIN for part of a query

    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.