Optimal Data Access - Teradata Database

Teradata Database Design

Teradata Database
Release Number
English (United States)
Last Update
Product Category

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 365 for details.