- Ordinary (heap organized table): Data is stored as an unordered collection (heap).
- Partitioned table: data is divided into smaller, more manageable pieces.
- Index-organized table (IOT): Rows (key and non-key values) are sorted and stored in a B-tree index structure.
- Clustered table: related data from more than one table are stored together. In other words, a cluster is a group of tables that share the same data blocks because they share common columns and are often used together.
May 16, 2008. InternalWorkings. .