15.00 - Group AMP Operations - Teradata Database

Teradata Database Design

Teradata Database
User Guide

Group AMP Operations

Sometimes less parallelism is best. Tactical queries, for example, are more efficient when they engage fewer resources. On the other hand, short queries often require more than one AMP and cannot be accommodated with single‑AMP processing alone. The Optimizer looks for opportunities to transform what would otherwise be all-AMP query plan into a few-AMP plan. This few‑AMPs approach is called Group AMP.

The Group AMP approach not only reduces the number of AMPs active in supporting a query, it also reduces the locking level from a table‑level lock to several partition and rowhash locks. Removing the need for table-level locks eliminates two all-AMP steps from the query plan:

  • A step to place the table‑level lock on all AMPs.
  • A step to remove the table‑level lock from all AMPs when the query completes.