Summary Information Window

Summary Information Window - Visual Explain

Teradata Visual Explain User Guide

Product

Visual Explain

Release Number

15.10

Language

English (United States)

Last Update

2018-10-07

dita:id

B035-2504

lifecycle

Product Category

Teradata Tools and Utilities

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

Figure 2: Summary Information Window

Table 1 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.

Table 1: 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. Note: This category appears only when the execution plan uses joins.
Join (all types)	Number of joins in the plan. Note: This category appears only when the execution plan uses joins.
Teradata Database Configuration Note: The categories listed change according to the cost parameter settings. For more information, see “Setting or Resetting Cost Parameters” on page 153.
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.