Estimated Cost Report
The Estimated Cost report provides cost estimates for each step. Use this report to analyze the cost estimate variations of two plans. For example, the cost differences of plans captured on two different configurations, or the differences of plans captured at two instances, or with changing demographics of tables.
To view the steps that take the most time or the least time to execute, double-click the column headings to sort the rows.
To emulate different physical configurations on one system and capture the plans, use the Set TLE and Reset TLE features of the Teradata System Emulation Tool application. For more information on target level emulation, refer to the Teradata System Emulation Tool User Guide B035-2492.
Figure 67 is an example of the report.
Figure 67: Sample Estimated Cost Report
Table 32 describes the information displayed on the Estimated Cost report.
|
Column or Row |
Description |
|
Step |
The number of a specific step in the plan. |
|
Estimated CPU Cost |
The estimated CPU cost of the step in hours, minutes, seconds, and milliseconds (HH:MM:SS:mm). |
|
Estimated IO Cost |
The estimated I/O cost of the step in hours, minutes, seconds, and milliseconds (HH:MM:SS:mm). |
|
Estimated Network Cost |
The estimated network cost of the step in hours, minutes, seconds, and milliseconds (HH:MM:SS:mm). |
|
Estimated Heuristic Cost |
The estimated heuristic cost of the step in hours, minutes, seconds, and milliseconds (HH:MM:SS:mm). |
|
Estimated Cost |
The estimated cost of the individual step in hours, minutes, seconds, and milliseconds (HH:MM:SS.mm). |
|
Cost Difference |
The absolute value of the cost difference for the specific step in hours, minutes, seconds, and milliseconds (HH:MM:SS.mm). |
|
% Difference |
The percent difference in the cost for the specific step. Steps that have a higher variance than the user‑specified threshold value are highlighted in red. |
|
Total Cost |
Called the summary row, the bottom row of the report displays the overall cost variance between the plans. The format of this row differs from the other rows to indicate that it is a summary row. |