A primary index can be either partitioned or nonpartitioned. Primary indexes for join indexes can also either be hash- or value-ordered, while primary indexes for all other table types are only hash-ordered.
The decision to define which of the two choices for a table depends on how its rows are most frequently accessed (see Single-Level Partitioning Case Studies). This topic describes the differences between the two types and their relative advantages and disadvantages.