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
- 13833 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 |
How do you Generate sequence at the time of Display?
How to eliminate product joins in a teradata sql query?
How do you create a table with an existing structure of another table with data and with no data?
Explain about Skew Factor?
Hello all, There is a table with 4 columns in that 3 columns has been already loaded with 5 million records.4th column is empty,Now I have got 5 million records data which has to be loaded into 4th column.How can I load this data fastly in to the 4th column with out using update
What do you mean by ttu in teradata?
why should we go Teradata over Oracle,what is the main differences?
What are default access rights in teradata?
what is differences between Fastload and Multiload as per DBA aspect ?
plz explain parlla distribution and subtable concept in teradata
What are the components used in smp and massively parallel processing (mpp) machines?
How to Skip or Get first and Last Record from Flat File through MultiLoad and TPUMP Utility?
Teradata 
