Archives of the TeradataForum

Message Posted: Wed, 21 Mar 2012 @ 15:34:34 GMT

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

All NULL PI records map to the same AMP via the hashing algorithm similar to the hashing of a non null field but I am unaware what the hash value/bucket would be or how the algorithm takes NULL as the input!!

However, I am interested to know based on which column would the NoPI tables (in v13) hash the records to store and retrieve.. V13 users, Do you have any info to share?

Regards,

Sowmya

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