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
What are the various indexes in teradata? How to use them?
What are the joins in teradata?
What are some primary characteristics of teradata?
what is object level locking ? where do appear this type of locking ?
How do you set the session mode parameters in bteq?
What's the difference between timestamp (0) and timestamp (6)?
Highlight the advantages of PPI(Partition Primary Index).
what are the uses of fact table and dimension table in banking project?
What is the use of fallback?
How many codd's rules are satisfied by teradata database?
Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.
How to view every column and the columns contained in indexes in teradata?
What is bteq script in teradata?
What is the function of parser component in teradata?
What is a level of granularity of a fact table?
