Interested to Buy Any Domain ? << Click Here >> for more details...
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 ?
- 2 Answers
- 14921 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
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 |
If a Node is busy what are the steps you can take to avoid ?
how teradata fetches a row from primary index table?
Describe the set operators in teradata.
What exactly do you know about catching in teradata?
The transaction exceeded the maximum number of rowhash locks allowed
What is differnce between Error code and Error Level in Bteq
What is the use of virtual processor connectivity in teradata?
What is the difference between union and union all in teradata?
How to relege locks in fastload and multiload? example?
Why is the case expression used in teradata?
What is meant by Teradata Gateway?
Hello Frndz, I have a table named product as shown below: product_id product_name 1 AAA 1 BBB 1 CCC 2 PPP 2 QQQ 2 RRR Now my output should be: product_id product_name_1 product_name_2 product_name_3 1 AAA BBB CCC 2 PPP QQQ RRR
Teradata 
