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 | 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:
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. |