Archives of the TeradataForum

Message Posted: Tue, 04 Apr 2006 @ 18:52:44 GMT

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

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.

My experience has been that trying to reduce blocks increases runtime. It is usually TPUMP blocking itself, or blocked by another query. By using a macro and one-at-a-time processing, TPUMP does not appear to block other queries for very long.

Bill H

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