Table Partitioning: The Good, the Bad and the Ugly
By Mark Gillis
Table (or Range) Partitioning has been around since V9.7. It’s a canny option and a useful tool from both a performance and a data archiving point of view, but we do occasionally see it mis-managed and then it can be more of a nuisance than a benefit.
Partitioned tables are organized into multiple storage objects according to a key, or set of keys, defined in the CREATE TABLE statement.