MySQL Forums
Forum List  »  Partitioning

Create partition on non key column
Posted by: Kapil Gupta
Date: May 26, 2016 05:51AM

I have lots of data(for example invoices) and everyday around 2000 invoices get created for different companies. I was thinking to do partitioning on invoice_creation_date column. But it is not a key column as there can be multiple invoices created on same date. I already have UUID column for primary key, but not able to create partition as invoice_creation_date is not a key column.
Please advice me best approach to deal with the same.

Options: ReplyQuote


Subject
Views
Written By
Posted
Create partition on non key column
676
May 26, 2016 05:51AM


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.