how to hashing primary index value

Database

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
N/A

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.

Re: how to hashing primary index value

thnx mnylin for good reply.