152k views
5 votes
How does an Index Organized table differ from a standard table and a typical index?

1 Answer

5 votes
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.
User Danilo Gomes
by
8.1k points