Describe how to partition an index-organized Table
Partitioning index-organized Tables
New to Oracle is the capability to partition an index-organized table.
Partitioning an index-organized table results in a table whose rows are stored in the exact order by primary key and are also segmented into individual sets of rows.
This can greatly reduce response time of a query that uses the primary key in its WHERE clause.
The following graphic illustrates the concept of dividing an index-organized table into partitions.
In the graphic, the CUSTOMER table is an index-organized table. This means that all the rows are arranged in order by primary key (in this case, the
ORDER_ID). The CUSTOMER table is divided into three partitions:
Use the CREATE TABLE command to create a partitioned, index-oriented table.
Look at the following MouseOver by clicking on the "Open Window" link for the syntax and an example of creating a partitioned table that is also an index-organized table.
Click the Open Window link.