Answer Posted / sat!sh
The data distribution of table among AMPs is called Skew Factor
Generally For Non-Unique PI we get duplicate values so the
more duplicate vales we get more the data have same rowhash
so all the same data will come to same amp, it makes data
distribution inequality,
One amp will store more data and other amp stores less
amount of data, when we are accessing full table, The amp
which is having more data will take longer time and makes
other amps waiting which leads processing wastage
In this situation (unequal distribution of data)we get Skew
Factor High
For this type of tables we should avoid full table scans
ex:
AMP0 AMP1
10000(10%) 9000000(90%)
in this situation skew factor is very high 90%
| Is This Answer Correct ? | 79 Yes | 3 No |
Post New Answer View All Answers
Different phases of multiload?
What is meant by a Least Cost Plan?
Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com
During the Display time, how is the sequence generated by Teradata?
Explain teradata utilities. What is multiload, fast load, tpump?
What is spool space? Why do you get spool space errors?
If RDBMS is halted what will you do ?
List out some of the primary characteristics of teradata.
What is the purpose of upsert command?
Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?
How does hashing happens in teradata?
What is the difference between union and union all in teradata?
Explain teradata architecture?
What is difference between user and database in teradata?
How do you determine the number of sessions?
