Explain about Skew Factor?

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


Please Help Members By Posting Answers For Below Questions

What is teradata and why it is used?

667


If a Node is busy what are the steps you can take to avoid ?

1971


What is a clique?

682


How to find duplicates in a table?

700


How can you track login parameters of users in teradata?

721






Define views in teradata with syntax.

723


what is object level locking ? where do appear this type of locking ?

3193


What are the newly developed features of Teradata?

664


How do you do backup and recovery in teradata?

645


How is the teradata different from oracle?

712


Explain teradata architecture?

723


How is MLOAD Client System restarted after execution?

691


What do you mean by parsing?

715


Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?

3134


How many codd's rules are satisfied by teradata database?

759