Displaying a Visual EXPLAIN Plan - Teradata SQL Assistant

Teradata® SQL Assistant for Windows User Guide

Product
Teradata SQL Assistant
Release Number
16.20
Published
October 2018
Language
English (United States)
Last Update
2020-01-03
dita:mapPath
gfk1537201040714.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2430
Product Category
Teradata Tools and Utilities
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
  • You are connected to a Teradata Database
  1. Select Tools > Visual Explain.
  2. In the Visual Explain dialog, enter the name of the Query Capture Database (QCD) and click OK.
    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, B035-2504.