HASHAMP in Teradata

HASHAMP identifies the AMP in which bucket is associated. HASHAMP takes bucket number as input and provides AMP number as output.

SELECT HASHAMP(HASHBUCKET (HASHROW ('Teradata'))) AS "AMP Num"


For performance optimization, first step is to ensure data is uniformly distributed across AMP's. If data is distributed uniformly in AMP's, skew factor will be low, thus query performs better.