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

Question

Itzel Curtis

Computers & Technology

14 June, 07:40

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

+3

Answers (1)

Know the Answer?

Allisson Escobar · 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.