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
Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?
What is the basic syntax for teradata select statement?
What is bteq script in teradata?
What are default access rights in teradata?
How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.
In Teradata, what is the significance of UPSERT command?
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
Differentiate primary key and partition key?
What are the various etl tools in the market?
What do you mean by teradata sql assistant?
If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?
How do you set the session mode parameters in bteq?
What is the difference between fastload and multiload? Which one is faster?
What tools would you use for that?
What is multi insert?