Partitioned indexes allow your data to be broken down into smaller, more manageable pieces called partitions, or even subpartitions. Each partition is stored in its own segment and can be managed individually. It can function independently of the other partitions, thus providing a structure that can be better tuned for availability and performance. Partitioning significantly improves query performance.
You can use Oracle Enterprise Manager to create a partitions for indexes. To add a partition to an index:
Navigate to the Database Home page.
On the Schema tab, click Indexes from the Database Objects section.
The Indexes Search page appears containing a results table listing all current indexes for the current database.
Click Create.
After naming the index, choose the Partitions sub tab to display the Partitions page.
Click Help for more information about indexes and partitions.
Enterprise Manager Information Roadmap
Copyright © 1996, 2010, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its affiliates.
Other names may be trademarks of their respective owners.