what is meant by Hot amp?
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 |
Why are oltp database designs not generally a good idea for a data warehouse?
How do you Generate sequence at the time of Display?
How is MLOAD Teradata Server restarted after execution?
What are the multiload utility limitations?
How is MLOAD Client System restarted after execution?
i have a table like sales....the field are Prodid Jan(jam month sales)Feb March 1 20 76 50 2 30 94 40 3 40 90 30 4 70 20 30 5 23 40 40 6 85 30 55 7 84 20 65 8 10 93 40 9 57 30 30 10 38 83 40 11 35 39 90 12 83 89 50 Now the Question is i want get the max sales of 12 products from the months.hint:for eg I WANT GET 89 for product12... Can any one help me
While creating table my dba has fallback or no fallback in his ddl. What is that?
What EXPLAIN does in Teradata, what is High confidence, Low confidence and No confidence.. And How we improve the query performance .
How do you create a table with an existing structure of another table with data and with no data?
What is the use of teradata system software?
how many modules are there in telecome domain?how to explain the architecture?
What are the frequently used data types in teradata?