How Teradata Visual Explain Works - Visual Explain

Teradata Visual Explain User Guide

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

How Teradata Visual Explain Works

Teradata Visual Explain reads the execution plan, which has been stored in the Query Capture Database (QCD), and converts the plan into a series of icons. View the execution plan either by entering a QCD using the Query Capture Facility (QCF), or by logging into the query plan using DBQL query logging.

Viewing an execution plan using QCF includes the INSERT EXPLAIN and INSERT EXPLAIN in XML commands (when connected to Teradata Database 13.10 and higher).

Viewing an execution plan without using QCF includes the EXPLAIN IN XML command, which generates the plan from an XML document (direct output from the database). Note that plan information is not stored on the database.

See “Entering a Query and Viewing Its Execution Plan” on page 84 and “View the Execution Plan” on page 64.