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.