MySQL Forums
Forum List  »  Data Warehouse

Re: Problem with granularity choosen
Posted by: Rick James
Date: May 11, 2012 07:54PM

PARTITIONing by day is an excellent way to carve up a table into manageable chunks.

No need for UNION; the table fetches one or more of the PARTITIONs, automagically.

Deleting the oldest 'day' is a ALTER TABLE REORGANIZE PARTITION DROP PARTITION.... To add a new day partition: ALTER TABLE REORGANIZE future INTO p20120512 VALUES LESS THAN TO_DAYS('2012-05-13'), future VALUES LESS THAN MAXVALUE;

Options: ReplyQuote

Written By
Re: Problem with granularity choosen
May 11, 2012 07:54PM

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.