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
2293
April 16, 2014 02:07PM
1233
April 18, 2014 05:19PM
1329
April 21, 2014 08:36AM
Re: BETWEEN a DATE and a hard place
1275
April 24, 2014 08:20PM
1459
April 25, 2014 06:36AM
1221
April 26, 2014 05:46AM
1273
April 28, 2014 07:27AM
1354
May 01, 2014 09:41AM
1373
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.