Administration Workshop II. 10-3. Table types

  • 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. Leave a comment.