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
What do you mean by tpt in teradata?
How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.
What is basic teradata query language?
If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.
why use references rather than pointers in the public api, particularly for arguments which are modified?
There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?
How many types of joins are there in teradata?
How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .
Where is teradata rdbms used?
What are the frequently used data types in teradata?
Explain the term 'row' related to relational database management system?
What is called partitioned primary index (ppi)?
What are the functions of a Parser?
What are the enhanced features in teradata v2r5 and v2r6?
Can you connect multiload from ab initio?
