Rebuilding an Index-Organized Table
An index-organized table is a B-tree index. It can become fragmented over time and can incur the same issues as a normal B-tree index: expanded index depth over time, an unbalanced tree, and sparse blocks, to name a few. Therefore, you can rebuild an index-organized table as you would a normal B-tree index. The obvious difference is that because it is regarded as a table, you rebuild an IOT with the ALTER TABLE command. See the following example:
SQL> ALTER TABLE employees_iot MOVE;
Table altered.
If you want to move the IOT to a different tablespace, simply specify the tablespace within the ALTER TABLE clause, as shown in the following examples:
SQL> ALTER TABLE employees_iot MOVE TABLESPACE emp_s;
Table ...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.
