Summary Information Window

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

The Summary Information window presents summarized information related to the displayed execution plan. The window opens in addition to the main window when viewing a plan.

Summary Information Window

The following table describes the information displayed in the Summary Information window. When comparing plans, the information in the Summary Information window changes according what is displayed in the main window.

Summary Information Window Description 
Summary Information Description
Execution Plan Details
Query ID Query ID number.
QCD QCD name.
Teradata Database Teradata Database name.
User User name.
Captured/Execution TimeStamp Date and time the execution plan was captured and executed in TIMESTAMP (0) format.
Multistep Parallelism Indicates whether parallelism is invoked.
Number of Steps Number of steps required to execute the plan.
Total Estimated Cost Estimated cost of executing the query.

Cost is displayed in hours, minutes, seconds, and milliseconds (HH:MM:SS.ss format).

Join Types Types of joins used in the execution of the query.
This category appears only when the execution plan uses joins.
Join (all types) Number of joins in the plan.
This category appears only when the execution plan uses joins.
Teradata Database Configuration
The categories listed change according to the cost parameter settings. For more information, see Setting or Resetting Cost Parameters.
Database Name Name of the database the user was connected to at the time the execution plan was captured.
Release Information When the plan is captured, the release level of the software loaded on Teradata Database. For example:
  • V2R.nn.nn.nn.nn for releases earlier than 12.00.00
  • nn.nn.nn.nn for release 12.00.00 and later

This attribute comes from the DBC.DBCInfoTbl system table.

Version Information The version of the Teradata Database software used when the plan was captured. For example, 05.01.02.03 represents the:
  • Major release number, 05
  • Minor release number, 01
  • Maintenance release number, 02
  • E-fix or patch release number, 03

These numbers come from the DBC.DBCInfoTbl system table.

Number of AMPs Number of AMPs on the system where the plan was captured.
Number of PEs Number of PEs on the system where the plan was captured.
Number of Nodes Number of nodes on the system where the plan was captured.