Interested to Buy Any Domain ? << Click Here >> for more details...
what is meant by Hot amp?
- 2 Answers
- 13779 Views
- IBM, Satyam, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / tdguy
highly non unique PI values, more number of null values can
create a hot amp condition., which means one or more amps
will be holding more rows than other amps. Distribution
occurs unevenly. This can cause out of spool space error.
| Is This Answer Correct ? | 5 Yes | 1 No |
How to identify ppi columns?
How many sessions of MAX is PE capable of handling at a particular time?
What is the meaning of Caching in Teradata?
Difference between client character set and server character set? What is the use of these two?default character set in teradata?
What is Join Index in TD and How it works?
what is identity columns in teradata
What are teradata utilities?
Difference between Teradata V2R5 and Teradata V12 versions?
What are the available primary index types in teradata.
What are the steps to create a data model?
Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?
id name gender 1 Ram Female 2 Kumar Female 3 sathish Female 4 Santhya Male 5 Durga Male 6 Priya Male This is my input...how to change Gender Male to Female & Female to Male??? Write sql query for this question???
Teradata 
