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 are the different softwares used with their functions in teradata?
What are the 5 phases in a multiload utility?
Explain the advantages of partitioned primary index in a query?
What are the multiload utility limitations?
If a Node is busy what are the steps you can take to avoid ?
What is a node in teradata?
Explain how spool space is used.
What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong
What is the maximum number of dml can be coded in a multiload script?
In Teradata, how do we Generate Sequence?
What is the purpose of indexes?
Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?
what is object level locking ? where do appear this type of locking ?
Explain BYNET.
