Viewing Query Execution - Visual Explain

Teradata Visual Explain User Guide

Product
Visual Explain
Release Number
16.20
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-05-04
dita:mapPath
pvi1488824663157.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2504
Product Category
Teradata Tools and Utilities
Monitor and retrieve information about a query in real time, when connected using CLIv2.

Connect to Teradata Database using CLIv2 before viewing query execution.

  1. Click . The Monitor SQL window opens and displays all the steps in the execution plan along with the actual cost, estimated cost, and cardinality information.
    The Monitor SQL feature is available only for SELECT statements.
  2. To access common functions, display the shortcut menu by right-clicking on the header row of the information grid, then choosing Copy, Find, Hide/Show Columns, Select All, Clear All, Save As, or Print.
  3. To view a graph comparing actual cardinality to estimated cardinality, click View Cardinality Graph.
  4. To view a graph comparing actual cost to estimated cost, click View Cost Graph.

    The query is resubmitted to Teradata Database to get the actual stepwise cost and cardinality. Only SELECT statements are resubmitted.