Displaying a Visual EXPLAIN Plan - SQL Assistant

Teradata SQL Assistant for Microsoft Windows User Guide

SQL Assistant
Release Number
English (United States)
Last Update
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
  • 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.