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
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.