Hash Partitioning reduces resource usage and internode communication.
To take advantage of hash partitioning, you need to create a new hash partitioned table, choose an appropriate high cardinality column as a partitioning key, and reload the data from an existing table into the newly created hash partitioned table. With hash-partitioning, queries on a large number of rows (of the order of 1 billion rows) use less temp space and perform better with a large number of cores. In a multiplex environment, hash-partitioning significantly reduces shared temp bandwidth requirements, allowing for better scale-out across multiple servers.