Answer Posted / guest
HOT AMP is a condition when data is NOT EQUALLY DISTRIBUTED
among AMPS and all the data is present in one or few AMPs.
In that case , when user fires SELECT query ,only the
processing power of one or few AMPs among many AMPs will be
used while others AMPS will be IDLE leading to the condition
called HOT AMPs in DB.
In case of HOT AMPs , query performance is very POOR.
Teradata Developer must try to choose PI in such a way that
uniquely distributes the data among AMPs and not lead to HOT
AMPs in Teradata Server.
| Is This Answer Correct ? | 13 Yes | 0 No |
Post New Answer View All Answers
What is collect statistics?
What is the difference between teradata and basic rdbms?
What are the various indexes in teradata? How to use them?
What are the components used in smp and massively parallel processing (mpp) machines?
What is teradata? Also, list out some of the primary characteristics of teradata.
Which is faster fastload or multiload?
What is teradata? What are some primary characteristics of teradata?
How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .
Why teradata is used?
What are the various indexes in teradata? How to use them? Why are they preferred?
Explain the term 'columns' related to relational database management system?
Explain vproc in teradata?
How will you solve the problem that occurs during update?
What do you mean by teradata intelliflex?
List out teradata data types?