IMP : New EXPLAIN Terminology

Database

IMP : New EXPLAIN Terminology

Hi Experts,

I run explain plan .

I encounter below new EXPLAIN terminology

*** are left outer joined using a rowkey-based sliding-window merge join (contexts = 1, 31),with a join condition of ****

Please tell/ explain me above EXPLAIN Terminology

Thanks in advance

Regards,
Mahesh.
1 REPLY
Teradata Employee

Re: IMP : New EXPLAIN Terminology

[font=Verdana][/font]When joining two PPI tables that have equivalent partition definitions, a Row Key
Match Scan within partitions can be used to join the tables together. Please specify the following inputs to analyse more:
1. Type of both tables joined - PPI/NPPI
2. PI defined on each table
3. Partioning columns
4. Join columns