Re: Partition by Date Column
You can use any function or expression that returns an integer type. Currently, however, optimisation is limited to TO_DAYS() and YEAR().
For partitioning by KEY(), you can use DATE/TIME/DATETIME columns directly and the performance should be about the same as with any other column type.
Jon Stephens
MySQL Documentation Team @ Oracle
MySQL Dev Zone
MySQL Server Documentation
Oracle
Subject
Views
Written By
Posted
17967
July 05, 2006 10:23AM
5954
July 24, 2006 09:01AM
5416
September 04, 2006 09:56PM
Re: Partition by Date Column
4726
September 05, 2006 05:07PM
6259
September 06, 2006 01:34AM
4276
October 03, 2006 12:06PM
5374
October 03, 2006 09:04PM
4202
October 25, 2006 08:45AM
4097
October 26, 2006 11:24PM
3942
January 28, 2009 02:08AM
4000
March 19, 2009 01:35AM
3752
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.