Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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 ?

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


Please Help Members By Posting Answers For Below Questions

What is the purpose of indexes?

1128


What is the difference between fastload and multiload?

1464


What is a three-tier data warehouse?

1153


What is multi insert?

1111


Why managing the data is important?

1059


Explain the term 'primary key' related to relational database management system?

1089


What are tpump utility limitations?

1176


What is bteq utility in teradata?

1027


What are the steps involved in the process flow of the sql statement through channel attached system?

1161


Explain teradata architecture?

1149


What are the steps involved after the disk manager passes the request?

1183


Name the five phases that come under MultiLoad Utility.

1032


When tpump is used instead of multiload?

1144


What's the difference between timestamp (0) and timestamp (6)?

1254


why use references rather than pointers in the public api, particularly for arguments which are modified?

1054