Optimal Data Access - Teradata Database

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.