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 do you mean by ttu in teradata?
How you will check the version of teradata?
Explain some differences between mpp and smp?
What are the primary characteristics of the Teradata.
What is the use of fallback?
How do you define Teradata?
Explain amp in teradata?
While creating table my dba has fallback or no fallback in his ddl. What is that?
What are the different table types supported by teradata?
What do high confidence, low confidence and no confidence mean in explain plan?
Explain and compare pros and cons of start schemas?
What is bteq utility in teradata?
Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?
Explain fallback in teradata?
Where is teradata rdbms used?