15.00 - Optimal Data Access - Teradata Database

Teradata Database Design

prodname
Teradata Database
vrm_release
15.00
category
User Guide
featnum
B035-1094-015K

Optimal Data Access

With respect to optimal data access using a primary index, you should consider the following factors.

  • The primary index should be chosen on the most frequently used access path.
  • For example, if rows are generally accessed by a range query, you should 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 you should 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 always single‑AMP operations.
  • See “Access Demographics” on page 417 for details.