MySQL Forums
Forum List  »  Partitioning

INTERVAL Partitioning
Posted by: Andrew A
Date: July 26, 2007 10:07AM

Hey,

Thought I would chuck this in here.

Like Oracle's INTERVAL partitioning system, you can schedule new partitions to automatically be created as specified by range.

For example, I may choose to do INTERVAL partitioning by RANGE on a day.

So that at the start of each new day (based off the timestamp column on a row) I want a new partition to take all rows with that day.

This is exactly what people (especially in a data warehouse environment) are after.

Ideally this sort of thing can be managed by the database and so time is spent developing and not having to write code to automate this ourselves :[

Cheers

Options: ReplyQuote


Subject
Views
Written By
Posted
INTERVAL Partitioning
8717
July 26, 2007 10:07AM
3402
July 26, 2007 10:46PM
3225
July 31, 2007 03:41PM
3461
August 09, 2007 05:04PM
3370
August 24, 2007 02:22PM


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.