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
What is database exceptions in teradata?
How to Extract data from multiple legacy systems?
What is the particular designated level at which a LOCK is liable to be applied in Teradata?
What is the purpose of using case expression in teradata?
What is collect statistics?
How do you see a ddl for an existing table?
What is primary index and secondary index?
What are the various indexes in teradata? How to use them? Why are they preferred?
What is basic teradata query language?
What is meant by a dispatcher?
What are the functions involved in shared information architecture?
How do you define Teradata?
What is spool space?
What are the design features involved in teradata?
In general, how do you optimze any sql in teradata?
