Merge Join question

Database
Enthusiast

Merge Join question

Hi , 

 

While going through various joins that are internal to Teradata such as Mege Join, Hash Join, Nested Join, etc, I came across something like below in teradata documentation blog. Could you explain what is PI Table Direct, PI Table Local in below matrix. Thank you. 

 

Merge Join Demographics

Merge Join Demographics

 

 

 

 

Table Direct

Table Local

Table Duplicated

Table Redistributed

PI Table Direct

        Not valid

        Not valid

        Valid

        Valid

PI Table Local

        Not valid

        Not valid

        Valid

        Valid

PI Table Duplicated

        Not valid

        Valid

        Not valid

        Not valid

PI Table Redistributed

        Not valid

        Not valid

        Not valid

        Valid

 

Tags (1)