How Teradata Visual Explain Works

Teradata Visual Explain User Guide

brand
Teradata Tools and Utilities
prodname
Visual Explain
vrm_release
16.10
16.20
category
User Guide
featnum
B035-2504-086K

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.