MySQL Forums
Forum List  »  Partitioning

Re: Partitioning using RIGHT function
Posted by: Phil Hildebrand
Date: July 24, 2008 08:49AM

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.

Options: ReplyQuote

Written By
Re: Partitioning using RIGHT function
July 24, 2008 08:49AM
October 08, 2008 08:49AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.