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 purpose of indexes?
What is the difference between fastload and multiload?
What is a three-tier data warehouse?
What is multi insert?
Why managing the data is important?
Explain the term 'primary key' related to relational database management system?
What are tpump utility limitations?
What is bteq utility in teradata?
What are the steps involved in the process flow of the sql statement through channel attached system?
Explain teradata architecture?
What are the steps involved after the disk manager passes the request?
Name the five phases that come under MultiLoad Utility.
When tpump is used instead of multiload?
What's the difference between timestamp (0) and timestamp (6)?
why use references rather than pointers in the public api, particularly for arguments which are modified?