Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 13 Nov 2006 @ 13:55:56 GMT


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


Subj:   Re: Questions on Nested Joins
 
From:   Anomy Anom

<-- Anonymously Posted: Monday, November 13, 2006 08:54 -->

Yes, it's possible to use Nested Join for outer join, though not likely.

The outer table (left table in case of left join) spool must be small enough that the optimizer is willing to duplicate it on all AMPs, and the ON conditions must cover a NUSI on the inner table.

USIs are never used for nested 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: 15 Jun 2023