MySQL Forums
Forum List  »  Partitioning

Partitioning tables
Posted by: David Usherwood
Date: March 21, 2011 12:02PM

Hi There,

I am currently constructing a key table for a new application that has multitude of datetime columns. Ideally I would like to partition the table on just one datetime field but with so many datetime fields I was just wondering:

Can a table only be partitoned by one datetime field into say 12 monthly partitons ? or can you partition by multiple datetime fields each with 12 monthly partitons ?



Many thanks for your help

Options: ReplyQuote


Subject
Views
Written By
Posted
Partitioning tables
2805
March 21, 2011 12:02PM
1091
March 21, 2011 04:12PM


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.