MySQL Forums
Forum List  »  Partitioning

Re: partition by range on decimal type
Posted by: Rick James
Date: November 23, 2012 09:03PM

> should it work somehow or never on decimal column?
I think "never".
PARTITION BY KEY, as I understand it, would be useful _only_ for "=" tests, not "range" tests. This is a "range":
> WHERE STARTTIME>=2012110900 and STARTTIME<=2012111623
The desired rows are scattered across most or all the partitions. (Even if not all, the optimizer can't figure that out, so it will check them all.)

Some new stuff in 5.5:
http://dev.mysql.com/tech-resources/articles/mysql_55_partitioning.html

My previous comments about FLOOR() may be wrong:
http://dev.mysql.com/doc/refman/5.1/en/partitioning-limitations-functions.html
http://dev.mysql.com/doc/refman/5.5/en/partitioning-limitations-functions.html
Still, those comments may apply to "=" tests and not "range".

Options: ReplyQuote


Subject
Views
Written By
Posted
3995
November 20, 2012 07:15AM
1760
November 21, 2012 10:39AM
1435
November 22, 2012 02:26AM
1515
November 22, 2012 11:02PM
1625
November 23, 2012 12:45AM
Re: partition by range on decimal type
1733
November 23, 2012 09:03PM


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.