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
Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?
What are default access rights in teradata?
How is the teradata different from oracle?
What type of indexing mechanism do we need to use for a typical data warehouse?
What is meant by a Virtual Disk?
What is meant by a Clique?
What happens in a conflict? How do you handle that?
What are the components provided on node?
What are the steps to create a data model?
What is collect statistics?
What is the purpose of using case expression in teradata?
Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?
What are default access rights in teradata? What explicit right can be given to a user?
How do you verify a complicated sql?
What is the difference between teradata and basic rdbms?