Residual Condition Report - Visual Explain

Teradata Visual Explain User Guide

Product
Visual Explain
Release Number
15.00
Language
English (United States)
Last Update
2018-09-27
dita:id
B035-2504
lifecycle
previous
Product Category
Teradata Tools and Utilities

Residual Condition Report

The Residual Condition report provides information about the predicate conditions applied on the table relations in a step. Only the steps where a residual condition is applied are displayed. Figure 70 is an example of the report.

Figure 70: Example of a Residual Condition Report

Table 35 describes the Residual Condition report.

 

Table 35: Residual Condition Report Columns and Descriptions 

Column

Description

Step

Specific step in the compare plan.

Predicate Kind

The predicate kind:

  • An additional join condition (A).
  • A range constraint (G). Used for value‑ordered relations.
  • A join condition (J).
  • A condition on a left relation in a join (L).
  • A partition elimination (Q). Occurs for a source condition. A residual condition on the left or right table in a join or on a single‑table retrieval. Partition elimination occurs prior to accessing the rows, so the condition applies only to rows retrieved from partitions that were not eliminated.
  • A condition on a right relation in a join (R).
  • A source condition (S). A residual condition on the left or right table in a join or on a single-table retrieval. No partition elimination occurs prior to accessing the rows.
  • Residual Condition

    A list of each predicate applied on a table in a step. A letter represents each predicate type:

  • A (additional join)
  • G (range constraint)
  • J (join condition)
  • L (condition on a left relation in a join)
  • Q (partition elimination)
  • R (condition on a right relation in a join)
  • S (source condition)