Teradata

AMP

The AMP is a unit of parallelism:

• Storing and retrieving data rows using the file system
• Aggregating data
• Joining processing between multiple tables
• Sorting and formatting output data

Insert

Parallel Query

Find all orders from today, along with the items ordered

SELECT *
FROM Orders o, Lines i
WHERE o.order= i.order
AND o.date = today()