All Forums Database
Amit Kumar 14 posts Joined 08/11
29 Aug 2011
how to hashing primary index value

hi all i am not clear about how to hash primary index value pls. give me some suggesions.

mnylin 118 posts Joined 12/09
01 Sep 2011

This is done automatically. You define a primary index as a set of columns and then when new data is loaded, Teradata will take the values in those columns, apply a hashing algorithm to them, and determine the appropriate AMP for that row. If you want to test the hashing algorithm, you can use the HASHAMP(HASHBUCKET(HASHROW(...))) functions around your columns.

Amit Kumar 14 posts Joined 08/11
02 Sep 2011

thnx mnylin for good reply.

You must sign in to leave a comment.