 |
 |
Archives of the TeradataForum
Message Posted: Tue, 04 Apr 2006 @ 19:31:06 GMT
| Subj: | | Re: TPUMP Blocking on multiple sessions |
| |
| From: | | Victor Sokovin |
| | Just let them happen, you can't avoid hash collisions, the fewer AMPs you have the more collisions you will have. Collisions are caused by
PI's being HASHed to the same AMP from both identical and different PI values. With 80 AMPs, and 22000 values, best case, even UPI will have 275
collisions per AMP. | |
Really? I did not know that. I thought hash collisions were much less frequent, Bill.
Regards,
Victor
| |
