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
- 14386 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 is difference between user and database in teradata?
How do you create tables? Exact syntax, and create profiles, users in teradata?
On which column will you take primary index???
What is the use of having index on table?
What is the use of virtual processor connectivity in teradata?
What are the types of tables in Teradata
22 Answers Cap Gemini, Cognizant, Infosys,
In the Primary Index, what is the score of AMPs that are actively involved?
How do you determine the number of sessions?
how to delete duplicate records in multi set table without using any tables
2 Answers Accenture, Nest, South Nests Software Solution, Spiro Solutions,
can we have an unconnected lkp to lookup a DB2 record against a Teradata record?
If the script is aborted. why it is aborted and how can you identify ?
What is meant by Teradata Gateway?
Teradata 
