Re: Partition by Date Column
Posted by:
Jake Peavy
Date: September 04, 2006 09:56PM
Edwin DeSouza Wrote:
-------------------------------------------------------
> Partition by Date Column:
>
> One of the most common usage of Partitioning is to
> partition
> by Date:
> - per Year, or
> - per Month, or
> - per Week, or
> - per Day.
>
> This blog entry shows how to handle this
> requirement using
> MySQL 5.1.
>
>
http://mikaelronstrom.blogspot.com/2006/07/partiti
> on-by-date-column_115211159472825345.html
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.
TIA,
-jp
Subject
Views
Written By
Posted
17598
July 05, 2006 10:23AM
5830
July 24, 2006 09:01AM
Re: Partition by Date Column
5243
September 04, 2006 09:56PM
4578
September 05, 2006 05:07PM
6101
September 06, 2006 01:34AM
4147
October 03, 2006 12:06PM
5164
October 03, 2006 09:04PM
4029
October 25, 2006 08:45AM
3939
October 26, 2006 11:24PM
3802
January 28, 2009 02:08AM
3842
March 19, 2009 01:35AM
3632
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.