Each step is composed of one or more operands and a target. The Operands report provides information about the operands for each step. These are also referred to as source relations.
Example of an Operand Report
The following table describes the Operands 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, All AMP Retrieve, Dynamic Hash Join, or Product Join. For more information, see: |
Target Relation | Indicates the related spool. |