Displaying a Visual 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 Visual EXPLAIN Plan

You can display a visual EXPLAIN of a single-statement query currently in the Query Window.

This menu command appears if:

  • You have the Teradata Visual Explain application (version 3.0 or later) installed on your PC, and
  • If you are connected to a Teradata Database
  • To display a Visual EXPLAIN plan

    1 Select Tools > Visual Explain.

    2 In the Visual Explain dialog box, enter the name of the Query Capture Database (QCD) and click OK.

    Note: It takes a few moments for the Insert Explain statement to execute, and you cannot continue using SQL Assistant until Visual Explain is launched.

    To set up a QCD, refer to the Teradata Visual Explain User Guide.