Building Secondary Indexes
The index-organized table can be viewed the same as a heap-organized table in that if other indexes are needed to speed query performance, secondary indexes can be added to index-organized tables because they can be added on heap-organized tables. See the following example to create a secondary index on DEPARTMENT_ID of the EMPLOYEES_IOT table:
SQL> CREATE INDEX employees_iot_1i
2 ON employees_iot (department_id);
You can also create secondary indexes on partitioned IOTs.
SQL> CREATE INDEX employees_iot_1i
2 on employees_iot (department_id)
3 LOCAL;
The key difference between secondary indexes on heap-organized tables and secondary indexes on index-organized tables is that there is no physical ROWID for ...
Get Expert Indexing in Oracle Database 11g: Maximum Performance for Your Database now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
