Index Organized Tables

Typical tables are heap organized. It has a stable physical location. It means, when we insert a new record it will be added to the next row of the table .

Index organized tables builds Table & Index together.
These are good for

• Small tables
• Exact match (Look up )

Create table state_lookup_IOT
(
stateid number,
State varchar(20),
City varchar(20),
primary key (id)
)
ORGANIZATION INDEX ;