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 many tables can you join in v2r5?
hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: rajeshmss87@gmail.com
how do you manage the production space. what are the proactive methods you can take ?
Highlight all the modes that are present under Confidence Level.
what are the day to day activities of teradata DBA ?
Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?
What are the different table types supported by teradata?
Mention the procedure via which, we can run Teradata jobs in a UNIX environment.
What is the meaning of Caching in Teradata?
What do you mean by teradata sql assistant?
What are the commands to make a new table, change a table and remove a table in teradata?
What is upsert statement in teradata?
What is logical data model?
What are some primary characteristics of teradata?
Give a justifiable reason why Multi-load supports NUSI instead of USI.