Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / navaneeth reddy
Skew factor is distribution of rows of a table among the
available no.of AMP's.
If your table has a chance of using unique primary index,it
is always better to use UPI which ensures the skew factor
around 0%.
If there is no chance of having unique values column in a
table choose a column as PI(primary index) which has less
duplicate values which inturn results in less skew factor.
That is the data will be distributed almost(not exactly
equal percentage) equally to all AMP's.
| Is This Answer Correct ? | 12 Yes | 0 No |
Post New Answer View All Answers
How to find duplicates in a table?
How can we check the version of Teradata that we are using currently?
What are the components provided on node?
Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!
What are some primary characteristics of teradata?
What are the functions involved in shared information architecture?
What happens when a node suffers a downfall?
What is dimensional modeling?
In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?
Describe the between keyword in teradata?
What is spool space? Why do you get spool space errors? How do trouble-shoot them?
Explain the term 'columns' related to relational database management system?
Why teradata is used?
List out all forms of LOCKS that are available in Teradata.
if collect stats but it show low confidence why?
