Partitioned Index-Organized Tables

Partitioned index-organized tables are very useful for providing improved performance, manageability, and availability for index-organized tables.

For partitioning an index-organized table:

• Partition columns must be a subset of the primary key columns.

• Secondary indexes can be partitioned (both locally and globally).

• OVERFLOW data segments are always equipartitioned with the table partitions.