Summary Information Window
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 WindowTable 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.
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 157. |
|
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: 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: 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. |