MySQL Forums
Forum List  »  Partitioning

Re: Partitioning on the basis of DAY() function
Posted by: Rick James
Date: August 04, 2010 09:38PM

Plan A: Have an extra column which contains (redundantly) the day of month.

Plan B: Do not go by day-of-month, but instead by seconds. That is partition by ranges that include 86400 seconds each, then deal with knowing which "day" is in which partition.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Partitioning on the basis of DAY() function
1483
August 04, 2010 09:38PM


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.