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 primary index and secondary index?
What is stored procedure in teradata?
What is a level of granularity of a fact table?
What are the different methods ot loading a dimension table? A fact table etc?
What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?
Explain the teradata primary index mechanics in detail with a diagram.
How would you load a very large file in teradata in general? What utility would you use for it? Why?
Highlight the need for Performance Tuning.
Explain teradata architecture?
Explain how spool space is used.
What are the various indexes in teradata? How to use them? Why are they preferred?
What are the multiload utility limitations?
how do you manage the production space. what are the proactive methods you can take ?
What is the command in bteq to check for session settings ?
Explain the types of join supports by teradata?
