Subjected to constant DML change activity,an index-organized table will deteriorate more rapidly than a regular BTree index.

Question

Quizplus · Accepted Answer

Index-organized tables (IOT) store the entire table in a B-tree index structure, so any DML changes will affect both the data and the index. This can lead to fragmentation and slower performance compared to a regular B-tree index, which only stores the index entries and not the actual data. Therefore, an IOT will deteriorate more rapidly than a regular B-tree index when subjected to constant DML activity.

Subjected to Constant DML Change Activity,an Index-Organized Table Will Deteriorate