MySQL Forums
Forum List  »  Partitioning

Re: Partitioning not working need primary key?
Posted by: newbie Shai
Date: October 25, 2012 09:45PM

Dear Rick,
Well about the integer I pretty must understand very well now.

This part I dont quite get you "If you are not partitioning on one of these fields: (`receiptID`,`outletID`), you will have not way to enforce the UNIQUEness of that tuple, except by your code." Well I would prefer to partition mainly by month so I keep anything more then 3 month into archive storage.

What do you mean by Adding a million values declared double(10,2) together is likely to be off by a few cents.

I am still studying your mini tutorial which is very useful many thanks for that. So when you "sumarry of tables" are you saying that I must run some kind of services to summarize into this tables right?

Options: ReplyQuote

Written By
Re: Partitioning not working need primary key?
October 25, 2012 09:45PM

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.