Re: Partition by Date Column
Hi,
> Does this mean that the functions QUARTER(),
> MONTH() or WEEK() (for instance) cannot be
> utilized by the partition optimizer? They do
> return integer values, but they weren't mentioned
> in either the blog post or your new partitioning
> article.
>
It means they cannot be used for range partitioning.
The way range partitioning is done is that we have the
range limits A and B, we apply the partition function
f to A and B and use this as the interval, thus interval
(A,B) is mapped to interval (f(A), f(B)) this does however
only work for functions f that are strictly non-decreasing
or strictly non-increasing. This is not true for the above
functions which are cyclical. YEARQUARTER, YEARMONTH, YEARWEEK
would however be ok if they existed (YEARWEEK does exist and
could thus easily be activated with this support).
Rgrds Mikael
> TIA,
> -jp
Subject
Views
Written By
Posted
17591
July 05, 2006 10:23AM
5829
July 24, 2006 09:01AM
5240
September 04, 2006 09:56PM
4574
September 05, 2006 05:07PM
Re: Partition by Date Column
6093
September 06, 2006 01:34AM
4140
October 03, 2006 12:06PM
5162
October 03, 2006 09:04PM
4024
October 25, 2006 08:45AM
3934
October 26, 2006 11:24PM
3801
January 28, 2009 02:08AM
3839
March 19, 2009 01:35AM
3629
April 06, 2009 08:15AM
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.