The AMPs - Advanced SQL Engine - Teradata Database

Database Introduction

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
qia1556235689628.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1091
lifecycle
previous
Product Category
Teradata Vantageā„¢

AMPs obtain the rows required to process the requests (assuming that the AMPs are processing a SELECT statement). The BYNET transmits messages to and from the AMPS and PEs. An AMP step can be sent to one of the following:

  • One AMP
  • A selected set of AMPs, called a dynamic BYNET group
  • All AMPs in the system

The following figure is based on the example in the next section. If access is through a primary index and a request is for a single row, the PE transmits steps to a single AMP, as shown at PE1. If the request is for many rows (an all-AMP request), the PE makes the BYNET broadcast the steps to all AMPs, as shown in PE2. To minimize system overhead, the PE can send a step to a subset of AMPs, when appropriate.