Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 18 Mar 2008 @ 01:34:38 GMT


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


Subj:   Re: Creating a table with a 0 skew factor
 
From:   McCall, Glenn David

  Also have a look at the hash functions in the "Functions and Operators" manual. You can use these to see where the rows in your table are going to. Example select hashamp( hashrow (pi_val1, pi_val_2)), pi_val1, pi_val2 from dummy_space_table;  


Oops, my example should of course read:

     select hashamp( hashbucket (hashrow (pi_val1, pi_val_2))), pi_val1,
     pi_val2
     from dummy_space_table;

But you would have seen that during your RTFM effort - wouldn't you!?!?!?


Glenn Mc



     
  <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: 27 Dec 2016