Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 03 Dec 2003 @ 14:58:01 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

Subj:   Re: Help on Explain
From:   Narayan Murthy

I do understand why & what is a two-AMP step, why & what a nested join is. The confusion is w.r.t the following : "two-AMP JOIN step " - what is this . I understand "two-AMP Retrieve step" which can be seen if an equality condition is placed on a USI, but two-AMP JOIN step ? - so what is that we are trying to join, with the two amps in picture and how does it take place.

W.r.t the above does the "nested join" apply to same context(i.e., is he talking about the same two-AMP JOIN) or is there a nested join performed after the two-AMP JOIN.


  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020