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
- 15014 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 |
what are the day to day activities of teradata DBA ?
How would you load a very large file in teradata in general? What utility would you use for it? Why?
Increasing no of amps will increase performance. Is this true?
in a BTEQ we have 2 insert 2 del 2 update statment. when the BTEQ is restarted i need to run the BTEQ from after DEL statment(means no need to run the insert & del stat).what is the logic for the above requirement?
What are the various indexes in teradata?
Where is teradata rdbms used?
what is sysdba and sysdbc ? which has high priority ?
Why FLOAD doesn't supports NUSI? Where as Mload supports NUSI. Please explain in this regard. Thanks in advance.
How to find duplicates in a table?
Find 2 highest sal from each dept who have completed 5 year in org
How to improve the query performance without taking the collect statistics? In explain plan i have 'NO CONFIDENT'.
Describe primary index in teradata?
Teradata 
