Interview Questions   Tutorials   Discussions   Programs   

Teradata - How many types of Skew exists? What is the difference between amp skew, data skew,cpu skew, io skew, delta amp cpu ?




1199
views
asked mar September 20, 2014 06:38 AM  

How many types of Skew exists? What is the difference between amp skew, data skew,cpu skew, io skew, delta amp cpu ?


           

1 Answers



 
answered By vishnoiprem   0  
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.
flag   
   add comment

Your answer

Join with account you already have

FF

Preview


Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!

Alert