Hi All,
can anyone tell me how many types of Skew exists? whats the
difference between amp skew,data skew,cpu skew, io skew,
delta amp cpu ?
Answer Posted / yuvaevergreen
Adding to above,
Cpu skew->
1 or more AMPs are processing most of the data while other
AMPs are processing very little data.
Max(CPUTime) / Avg(CPUTime) from Ampusage can also give a
CPU skew figure.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What is the basic syntax for teradata select statement?
What is the particular designated level at which a LOCK is liable to be applied in Teradata?
Explain the term 'foreign key' related to relational database management system?
How to run a query in teradata?
What are the scenarios in which full table scans occurs?
What is the use of fallback?
What are the components used in smp and massively parallel processing (mpp) machines?
what are the uses of fact table and dimension table in banking project?
What are the joins in teradata and how many types of joins are there in teradata?
How do you do backup and recovery in teradata?
Explain Teradata performance tuning and optimization?
i learn teradata,it is so intersting,now i want teradata certifications ,so any 1 help me to get teradata certifications TD 12 ? email:kdcrazyy@gmail.com
Highlight the advantages of PPI(Partition Primary Index).
What is teradata?
What is the meaning of Caching in Teradata?