Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 29 Dec 2006 @ 11:27:29 GMT


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


Subj:   Re: How to prevent high skewness between large_tableA join large_tableB
 
From:   Li, Zhong

Hi, Terry:

Thanks for your suggestion, I think it is a great idea to separate the Even distributed data and uneven distributed data by specific values, But these specific values probably are unstable and increasing in the future, So I should adjust UNION sql statement based on the above change,

Do you think is it possible to use secondary index or join index or Hash index to prevent high skewness for tableB on column b1 and b2?


Regards

David



     
  <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