The Step Information report displays the source relations used and the target relations built in a step along with the operation performed and cost estimates. Cost is displayed in HH:MM:SS.ss format.
Use this report to get information about the operands, operation, target, and estimated cost. The step attribute values display if they are available for any one of the plans. When there are multiple step attributes for a given step, the attributes are split across different rows.
Sample Step Information Report
The following table describes the Step Information report.
Column | Description |
---|---|
Step | Specific step number in the compare plan. |
Left Relation | Name of the left relation in a step. |
Right Relation | Name of the right relation in a step. |
Operation | Type of operation performed. For example, Retrieve, Aggregate, or Join Method. For more information, see Retrieval-Method Icons, Aggregate-Step Icons, Join-Method Icons, and Other Operation Icons. |
Target Relation1 | Name of the first target relation in a step. |
Target Relation2 | Name of the second target relation in a step. |
Estimated CPU Cost | Estimated CPU cost of the step in hours, minutes, seconds, milliseconds (HH:MM:SS:mm). |
Estimated IO Cost | Estimated I/O cost of the step in hours, minutes, seconds, milliseconds (HH:MM:SS:mm). |
Estimated Network Cost | Estimated network cost of the step in hours, minutes, seconds, milliseconds (HH:MM:SS:mm). |
Estimated Heuristic Cost | Estimated heuristic cost of the step in hours, minutes, seconds, milliseconds (HH:MM:SS:mm). |
Estimated Cost | Estimated cost of the step in hours, minutes, seconds, milliseconds (HH:MM:SS.ss). |
Attribute Name | Additional information for the step depending on the operation performed; such as the following:
This column only appears if step attribute values are defined for at least one of the plans.
|
Attribute Value | Value of the step attribute type; such as the following:
This column only appears if step attribute values are defined for at least one of the plans.
|