Thursday, August 04, 2005

Great idea on Partition Management

I sat down thinking about what ways to manage your partitions in a partitioned table.
To be able to add and drop partitions in various ways for the various types of partitions
are more or less obvious. But there are a great number of other changes desirable like
merging partitions, splitting partitions, changing ranges of partitions and so forth. So
either one could define a whole battery of special commands for every special situation
(and naturally write code for each and every one of them as well).

So I found a solution where one defines the set of partitions to reorganise and then defines
the partitions to reorganise them into. This single method can be specialised to merge
partitions, split partitions, change range conditions, change list of values for partitions and
so forth.

No comments: