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
8659
July 26, 2007 10:07AM
3379
July 26, 2007 10:46PM
3208
July 31, 2007 03:41PM
3438
August 09, 2007 05:04PM
3356
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.