Residual Condition Report

Teradata Visual Explain User Guide

brand
Teradata Tools and Utilities
prodname
Visual Explain
vrm_release
16.10
16.20
category
User Guide
featnum
B035-2504-086K

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.

Example of a Residual Condition Report

The following table describes the Residual Condition report.

Residual Condition Report Columns and Descriptions 
Column Description
Step Specific step in the compare plan.
Predicate Kind Predicate kind:
  • Additional join condition (A).
  • Range constraint (G). Used for value-ordered relations.
  • Join condition (J).
  • Condition on a left relation in a join (L).
  • 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.
  • Condition on a right relation in a join (R).
  • 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 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)