Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 10 Aug 2004 @ 23:37:37 GMT


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


Subj:   Re: Redistribution Vs Duplication
 
From:   Christie, Jon

Are you joining on the primary index of the large table? That is, do you have connecting terms between the tables that cover every column of the large table's primary index and is the operator in each term = ?

If so, I'm very surprised you're not getting a merge join where the large table is accessed directly. If not, I'm not surprised at all. Perhaps you should show us the query, the DDL and the explain.


Jon



     
  <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