Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 08 Jan 2004 @ 16:45:09 GMT


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


Subj:   Re: How to know how the hashing algorithm works
 
From:   John Adams

On Thu, 8 Jan 2004 17:20:08 +0100, Dieter Noeth wrote:

  According to the Physical Implementation training: The hashing algorithm uses multiplication and addition as commutative operators for handling a multi-column index.  


  PI(A, B) = PI(B, A)  


  Hash (A) * Hash (B) + Hash (A) + Hash (B) =
Hash (B) * Hash (A) + Hash (B) + Hash (A)
 



Thanks! That's the specific question which was raised and on which I'd pretty much satisfied myself by experimentation so far as the results were concerned, but it's always good to know more about the innards. (Can you guess I spent too much of my youth watching my dad clean game?)

Any other information would be gratefully received--I never got to take that class.


Thanks again,

John A



     
  <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