Data Types And Hashing
The data types for the primary index column set also have an important effect on how rows hash. For example, a primary index value typed DECIMAL with one precision generally hashes to a different AMP than the same primary index value typed DECIMAL with a different precision (see “Hashing and Data Types” on page 198 for additional information).