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 is a clique?
How do you verify a complicated sql?
Give the sizes of SMALLINT, BYTEINT and INTEGER.
How many types of joins are there in teradata?
Explain the term 'primary key' related to relational database management system?
How many sessions of MAX is PE capable of handling at a particular time?
What are some commonly used bteq scripts?
Explain amp in teradata?
What is the use of having index on table?
How do you create tables? Exact syntax, and create profiles, users in teradata?
Differentiate primary key and partition key?
if collect stats but it show low confidence why?
Discuss the advantages of using partitioned primary index in a query?
My table got locked during mload due to a failed job. What do I do to perform other operations on it?
Explain teradata architecture?
