Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / sricharan
It is a number.It tells you how the data is distributed
among Processors or Amps.Skew factor varies about 0-100.
If the data is distributed evenly among the processor the
skew factor is ZERO whether it is smaller or large table.
Skew factor doesn't depends on size of table but it only
depends on distribution of data.
If the skewfactor is more we have to access the table on
only primary index columns but not whole table.
| Is This Answer Correct ? | 26 Yes | 0 No |
Post New Answer View All Answers
Explain some differences between mpp and smp?
What is the purpose of using case expression in teradata?
How many codd's rules are satisfied by teradata database?
What are the different design perspectives used in teradata?
What is the use of teradata system software?
What are the uses of bynets in multi-node systems?
What is meant by a Parsing Engine?
If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.
Explain the advantages of partitioned primary index in a query?
What is bteq utility in teradata?
What are the different table types supported by teradata?
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
What are the design features involved in teradata?
What is the use of having index on table?
What are the available primary index types?
