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 / innocent
How many types of Skew exists?
If you utilized unequally TD resources(CPU,AMP,IO,Disk and
etc) this is called skew exists. Major are 3 type of skews
(CPU skew,AMP/Data skew, IO Skew).
-Data skew?
When data is not distribuited equally on all AMPs.
-Cpu skew?
Who is taking/consuming more CPU called cpu skew.
-IO skew?
Who perform more IO Operation. called IO Skew.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What is the use of having index on table?
What are some primary characteristics of teradata?
What do you mean by tpt in teradata?
What does sleep function does in fast load?
Describe primary index in teradata?
How to eliminate product joins in a teradata sql query?
What is the function of parser component in teradata?
what are the day to day activities of teradata DBA ?
What is the difference between teradata and basic rdbms?
Explain the meaning of Amp?
What is oltp?
What is database exceptions in teradata?
What is the difference between teradata and oracle?
Explain teradata architecture?
What is the purpose of upsert command?