how to hashing primary index value

Database
Enthusiast

how to hashing primary index value

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

2 REPLIES
Enthusiast

Re: how to hashing primary index value

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.
Enthusiast

Re: how to hashing primary index value

thnx mnylin for good reply.