Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'd like to know if it is better to use a RANGE RIGHT partition scheme or a RANGE LEFT partition scheme?

Is one of these options by default a better choice, or is it heavily dependent on the actual data?

Once you've already used a RANGE LEFT, how difficult is it to switch to a RANGE RIGHT? Or is it easier to just add in splits in the current scheme?

share|improve this question
up vote 7 down vote accepted

It's not a question of better or worse, but business requirements will drive that choice. For instance, we're talking about whether or not you want your defined boundary values to live in one partition or the next.

An example of a boundary value of '9/12/2013', would you want that boundary valued data to live in partition x (range left) or partition x + 1 (range right)? This will especially come into play when you're thinking about things like individual partition management, as well as partition switching for purposes such as archiving.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.