what is amp plz explanation

Answer Posted / tdguy

Access Module Processor stores and retrieves the
distributed data in parallel. Ideally, the data rows of
each table are distributed evenly across all the AMPs.
Their job is to receive the optimized plan steps, built by
the PE after it completes the optimization, and execute
them.

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Difference between stored procedure and macro?

787


What are default access rights in teradata?

721


Define views in teradata with syntax.

724


Explain the term 'columns' related to relational database management system?

648


Highlight the points of differences between the database and user in Teradata.

683






What is a node in teradata? Explain

676


In Teradata, how do we Generate Sequence?

684


How do you see a ddl for an existing table?

667


What is bteq utility in teradata?

645


What are the newly developed features of Teradata?

664


Highlight a few of the advantages that ETL tools have over Teradata.

727


Explain the teradata primary index mechanics in detail with a diagram.

656


What is collect statistics?

669


What is teradata? Also, list out some of the primary characteristics of teradata.

667


What exactly do you know about catching in teradata?

724