Re: Partitioning using RIGHT function

[Phil Hildebrand]

If you don't have to have knowledge of which value is in which partition after adding additional partitions (IE: if I start with 10 partitions, and then decide to have 12), then you could just use a hash partition.

So, partition by hash (number) partitions 10.

This will essentially use mod (number) to place the given row into partition x.

The drawback is that when you add a partition or two, you will no longer be able to guarantee that number 59 is in partition 9, but that's usually not an issue.