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
How you will check the version of teradata?
Discuss the advantages of using partitioned primary index in a query?
What can be achieved by using the teradata rdbms?
Explain the parallel data extension in teradata?
Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com
Highlight a few of the advantages that ETL tools have over Teradata.
What tools would you use for that?
How do you see a ddl for an existing table?
What is the difference between teradata and oracle?
What are default access rights in teradata? What explicit right can be given to a user?
What is bteq script in teradata?
Comment whether bottleneck is an error or not.
Highlight the advantages of PPI(Partition Primary Index).
Explain the teradata primary index mechanics in detail with a diagram.
How to load specific no.of records using bteq, or fastload,or multiload