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
How would you load a very large file in teradata in general? What utility would you use for it? Why?
If RDBMS is halted what will you do ?
Can you connect multiload from ab initio?
Explain the parallel data extension in teradata?
What are the steps involved after the disk manager passes the request?
What is database exceptions in teradata?
What is meant by a node?
What are the components used in smp and massively parallel processing (mpp) machines?
if collect stats but it show low confidence why?
What are the different softwares used with their functions in teradata?
What are the updated features of teradata?
What is collect statistics?
Explain the term 'tables' related to relational database management system?
Where is teradata rdbms used?
what is sysdba and sysdbc ? which has high priority ?