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
- 14920 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?
What does Amp contain and what are all the operations that it performs?
What is called partitioned primary index (ppi)?
What are the various indexes in teradata? Why are they preferred?
What do you mean by caching in teradata?
What is meant by a Highest Cost Plan?
What are the various indexes in teradata?
What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?
How can we check the version of Teradata that we are using currently?
What is meant by a Channel Driver?
How many types of joins are there in teradata?
Highlight all the modes that are present under Confidence Level.
Explain vproc in teradata?
Highlight the points of differences between the database and user in Teradata.
Why teradata is used?
