 |
 |
Archives of the TeradataForum
Message Posted: Thu, 08 Jan 2004 @ 16:45:09 GMT
| 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. | |
| | 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
| |
