Mar
13
2019

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.

Overview

Partitioned tables are organized into multiple storage objects according to a key, or set of keys, defined in the CREATE TABLE statement.

Continue reading

Have a Question?

Get in touch with our expert team and see how we can help with your IT project, call us on +44(0) 870 2411 550 or use our contact form…