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
- 14885 Views
- I also Faced
- E-Mail Answers
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
How many codd's rules are satisfied by teradata database?
What type of indexing mechanism do we need to use for a typical data warehouse?
How do you set the session mode parameters in bteq?
Explain and compare pros and cons of snow flake schemas?
Give a justifiable reason why Multi-load supports NUSI instead of USI.
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u
Explain the advantages of partitioned primary index in a query?
What are the updated features of teradata?
How do you verify a complicated sql?
How many types of joins are there in teradata?
What are the design features involved in teradata?
What is multi insert?
What is meant by a node?
What is database exceptions in teradata?
