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 teradata utilities?
What tools would you use for that?
What are types of partition primary index (ppi) in teradata?
In the Primary Index, what is the score of AMPs that are actively involved?
Explain the advantages of partitioned primary index in a query?
Define views in teradata with syntax.
What are the various indexes in teradata? How to use them?
What is the use of virtual processor connectivity in teradata?
What do you mean by fastexport in teradata?
Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com
what are the uses of fact table and dimension table in banking project?
What is the purpose of joins in teradata?
What is primary index and secondary index?
Explain the most common data types used in teradata?
How to Extract data from multiple legacy systems?