Partition tables

Table partitioning can improve performance. Table partitioning is a data organization scheme in which table data is divided across multiple storage objects called data partitions or ranges, according to values in one or more table columns.

With table partitioning, each index can be placed in its own table space, regardless of the table space type. Each data partition is stored separately. These storage objects can be in different table spaces, in the same table space, or a combination of both.

Without table partitioning, all indexes for a particular table are stored in the same storage object by default.