Partition for Improved Performance
A key requirement of high performance, high availability database environments, partitioning splits tables and indexes into smaller, more manageable components. Oracle Database 11g offers the widest choice of partitioning methods available, including interval, reference, list, and range. Additionally, it provides composite partitions of two methods, such as order date (range) and region (list) or region (list) and customer type (list). As an option to Oracle Database 11g Enterprise Edition, Oracle Partitioning is also the foundation of Oracle's Information Lifecycle Management strategy, which aligns the business value of information to cost-effective storage tiers for large data warehousing and transaction processing applications.