MySQL Forums
Forum List  »  Partitioning

Re: No other way than delete primary key to create partitions by single datetime columns?
Posted by: Rick James
Date: August 22, 2015 03:35PM

Did you consider adding this, instead of PARTITIONing?

INDEX(createDate)

What query is 'slow'? Maybe some other index would be even better. For example, if you have

WHERE col3 = 123 AND createDate BETWEEN ... AND ...

then this would be optimal (and _better_ than partitioning):

INDEX(col3, createDate)

I'm not saying that PARTITION is _useless_; I am saying that you have not presented a case where it is _more useful_ than some index.

Options: ReplyQuote




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.