|
When should we go for hash partitioning?Scenarios for choosing hash partitioning:
- Not enough knowledge about how much data maps into a give range.
- Sizes of range partition differ quite substantially, or are difficult to balance manually
- Range partitioning would cause data to be clustered undesirably.
- Features such as parallel DML, partition pruning, joins etc are important.
|
