Re: BETWEEN a DATE and a hard place
Posted by:
Rick James
Date: April 24, 2014 08:20PM
> obviously, wrap around randomly.
> PARTITION BY RANGE ( DAYOFYEAR(dev_tz_date) % 100 ) (
That defeats the optimizer's ability to do partition pruning much of the time.
> I wanted to use a RANGE PARTITION but find the syntax too cumbersome
Too bad, you need it.
> Is there another way to specify RANGE partitions?
Yes. Here it is on a silver platter:
http://mysql.rjweb.org/doc.php/partitionmaint
Subject
Views
Written By
Posted
2344
April 16, 2014 02:07PM
1259
April 18, 2014 05:19PM
1358
April 21, 2014 08:36AM
Re: BETWEEN a DATE and a hard place
1305
April 24, 2014 08:20PM
1485
April 25, 2014 06:36AM
1257
April 26, 2014 05:46AM
1298
April 28, 2014 07:27AM
1392
May 01, 2014 09:41AM
1400
May 02, 2014 11:39AM
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.