MySQL Forums
Forum List  »  Partitioning

Sub partitions
Posted by: AR Mahdi
Date: January 12, 2010 03:09AM

Hi,

I am new to the partitioning concept. I am trying out something in the mysql DB

Is it possible to have partitions within a partition or sub partitions within a partition.
for Example i can have a partition on a table by date then i want to make a partition within that partition on hash. so my table will be further divided

is that possible or not.

Why i want to do this is because in my application we either are going to make an archives table or we will use the partitioning. Why i want to use the partitioning is because we will still be using the archived data in certain special cases when we will need all the archived data.

I will appreciate ur help

Options: ReplyQuote


Subject
Views
Written By
Posted
Sub partitions
4182
January 12, 2010 03:09AM
2146
January 13, 2010 04:51AM


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.