|
|
Archives of the TeradataForum
Message Posted: Wed, 21 Mar 2012 @ 20:27:04 GMT
Subj: | | Re: How records get hashed if PI value is NULL? |
|
From: | | abhishek.gupta |
As per Teradata 13 manuals:
Without a PI, the hash value as well as AMP ownership of a row is arbitrary. Within the AMP, there are no row-ordering constraints and
therefore rows can be appended to the end of the table as if it were a spool table. Each row in a NoPI table has a hash bucket value that is
internally generated.
Regards
Abhishek Gupta
| |