Partitioning Enhancements

Partitioning Enhancements

New MERGE PARTITIONS option as part of the ALTER TABLE clause. – merge 2 adjacent partitions of a table if the range method was used.
Updateable Partition Keys – New option as part of the CREATE or ALTER TABLE command ENABLE ROW MOVEMENT allows a row to automatically migrate to a different partition if the partition key value is updated and should now exist in a different partition.
2 New Partition Methods – Hash and Composite
Performance improvements using Partitions – Enhanced partition elimination and partition-wise joins. Enhanced partition elimination reduces the number of partitions used in a query and partition-wise joins allow for better performance when joining partitioned tables.
New support for LOB’s within a partitioned table.
Partitioning of Index-Organized Tables – Direct path loading option within SQL*Loader is also supported for IOT’s.