Interested to Buy Any Domain ? << Click Here >> for more details...
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
How to select first n records in teradata?
During the Display time, how is the sequence generated by Teradata?
Explain the new features of teradata?
Why teradata is used?
What is meant by a Least Cost Plan?
How to find duplicates in a table?
What is a node in teradata? Explain
What is the purpose of joins in teradata and what are the available join types?
What happens in a conflict? How do you handle that?
What are the joins in teradata and how many types of joins are there in teradata?
How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.
What is the command in bteq to check for session settings ?
Highlight the limitations of TPUMP Utility.
What are the components used in smp and massively parallel processing (mpp) machines?
Highlight the advantages of PPI(Partition Primary Index).
