13.3. Understanding Special Table Types
Two special table types—index-organized tables and clustered tables—provide a number of performance-related and space-related benefits compared to the traditional heap-based tables. In the sections that follow, we will show you how to create, maintain, and use both of these table types in your database to maximize your disk space usage.
13.3.1. Index-Organized Tables
An index-organized table (IOT) is one special type of table that is most effective when the access of the table is primarily by the primary key and the primary key columns constitute a large part of the table's columns. In the following sections, we will present an overview of IOTs, show you how to create an IOT, manage the non-primary key ...