Source Attributes Report

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

Product Category

Teradata Tools and Utilities

The Source Attributes report displays the attributes of the source operands at each step. Each step has two rows, one for the left relation and the other for the right relation. Figure 73 is an example of the report.

Figure 73: Sample Source Attributes Report

Table 38 describes the Source Attributes report.

Table 38: Source Attributes Report Columns and Descriptions
Column	Description
Step	Identifies the specific step in the compare plan.
Relation	Identifies the type of relation (left or right).
Name	Identifies the name of the relation.
Sorted	Indicates whether the relation is sorted.
Cached	Indicates whether the relation is cached.
SyncScan	Indicates whether a relation is eligible for synchronized scanning.
Partitioned	Indicates whether a table or spool has a partitioned primary index.
Partition Count	Indicates the number of partitions on a table.
Sort Kind	Identifies the way the relation is sorted: Field1 sort Field1 unique sort Field1 Hash sort FieldID sort Field1 Hash unique sort Field1 Hash min1 sort Field1 Hash min2 sort Field1 Hash max1 sort Field1 Hash max2 sort JoinIndex sort Field1 min1 sort Field 1 min2 sort RowHash field1 sort RowHashRow sort RowHash sort Unique field1 sort Unique rowID sort Unknown sort kind
Sort Key	If the relation is sorted, lists the sort information strings. The format of the individual SortKey strings is one of the following: database_name.table_name.column_name SPOOL number.column_name