MySQL Forums :: Partitioning :: Create partition on non key column


Advanced Search

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 613 Kapil Gupta 05/26/2016 05:51AM
Re: Create partition on non key column 378 Rick James 05/29/2016 12:28AM


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.