With respect to optimal data access using a primary index, consider the following factors.
- Choose the primary index on the most frequently used access path.
For example, if rows are typically accessed by a range query, consider defining a partitioned primary index on the table or join index that creates a useful set of partitions.
If the table is frequently joined with a specific set of tables, then consider defining the primary index on the column set that is typically used as the join condition.
- Primary index operations must provide the full primary index value.
- Primary index retrievals on a single value are single-AMP operations.