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.
Subject
Views
Written By
Posted
3951
August 03, 2010 07:09AM
Re: Partitioning on the basis of DAY() function
1622
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.