How does an Index Organized table differ from a standard table and a typical index?

Question

Computers and Technology

Guest

28 July, 08:02

How does an Index Organized table differ from a standard table and a typical index?

+3

Answers (1)

Know the Answer?

Sara Young · Answer 1

The thing is that an Index organized table, also known as IOT, is a type of table that stores data in a B tree index structure, which is used by Oracle. Normal relational tables, called heap-organized tables, store rows in any order and primary key indexes store only the columns included in its definition.