Join Strategy followed

General
Enthusiast

Join Strategy followed

Hello All,

Can someone help me understand the join strategies followed by Teradata for each of the below join scenarios between 2 tables ? I tried many times to understand looking at explain plan, but still helpless.

1. PI joined to PI

2. PI joined to Non-PI

3. PI joined to SI

4. Si joined to SI

5. PI joined to PPI

6. SI joined to PPI

7. PI joined to JI

8. PPI joined to JI

Will it make difference if PPI is part of PI and if it's not?

(Please read PI- Primary index, SI - Seconday index, JI - Join index, PPI - Partition Primary Index)

Tags (2)