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:

My previous comments about FLOOR() may be wrong:
Still, those comments may apply to "=" tests and not "range".

Options: ReplyQuote

Written By
November 20, 2012 07:15AM
November 21, 2012 10:39AM
November 22, 2012 02:26AM
November 22, 2012 11:02PM
November 23, 2012 12:45AM
Re: partition by range on decimal type
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.