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 does hashing happens in teradata?
Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?
What is the use of fallback?
Did you write stored procedures in teradata?
Write a program to show the parser component used in teradata?
Highlight the differences between Primary Key and Primary Index.
What is logical data model?
how can we analyze the locks ?
What do you mean by caching in teradata?
What type of indexing mechanism do we need to use for a typical data warehouse?
how do you manage the production space. what are the proactive methods you can take ?
What are the different table types supported by teradata?
What are the newly developed features of Teradata?
Why do you get spool space errors? How do trouble-shoot them?
Give a justifiable reason why Multi-load supports NUSI instead of USI.
