Row-partitioned and Nonpartitioned Primary Indexes
A primary index can be either row-partitioned or nonpartitioned. Primary indexes for hash and join indexes can also either be hash‑ or value‑ordered, while primary indexes for all other table types are hash‑ordered only.
The decision to define which of the two choices for a table depends on how its rows are most frequently accessed (see “Row‑Partitioned and Nonpartitioned Primary Index Access for Typical Operations” on page 403 and “Single‑Level Partitioning Case Studies” on page 370). This topic describes the differences between the two types as well as their relative advantages and disadvantages.