Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>   <<First <Prev

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
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020