Re: Auto Partitioning using unix time

[Mikael Ronström]

Jason Lewis wrote:
> Mikael Ronstrom wrote:
> > To use the partition function PARTITION BY
> > RANGE/LIST (TO_DAYS(a_date_field))
> > will have a very good effect on the
> optimizer
> > since it will then know that it can apply
> > range optimisations.
> >
>
> Does the "date_field" have to be a mysql defined
> date data type?

It has to be of DATE or DATETIME to get the positive effects
for partition pruning.

Rgrds Mikael

Mikael Ronstrom
Senior Software Architect, MySQL AB
My blog: http://mikaelronstrom.blogspot.com