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.
Sample Source Attributes Report
The following table describes the Source Attributes report.
|Step||Specific step in the compare plan.|
|Relation||Type of relation (left or right).|
|Name||Name of the relation.|
|Sorted||Whether the relation is sorted.|
|Cached||Whether the relation is cached.|
|SyncScan||Whether a relation is eligible for synchronized scanning.|
|Partitioned||Whether a table or spool has a partitioned primary index.|
|Partition Count||Number of partitions on a table.|
|Sort Kind||Way the relation is sorted:
|Sort Key||If the relation is sorted, lists the sort information strings. The format of the individual SortKey strings is one of the following: