1.what is activity count?
2.what is skew factor?
how it's working explain brefily
Answer Posted / tdguy
activity count - rows processed by sql.
skew factor - distribution of data over the amps.
when the distribution is highly skewed, the amp working may
be affected, which inturn affects parallelism.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Discuss the advantages of using partitioned primary index in a query?
What is the use of stored procedures in teradata?
What is a clique?
What are the design features involved in teradata?
What are tpump utility limitations?
How is MLOAD Teradata Server restarted after execution?
Difference between multiload and tpump?
What is meant by a Highest Cost Plan?
Explain the meaning of Amp?
What are the functions involved in shared information architecture?
Explain the term 'columns' related to relational database management system?
Why are oltp database designs not generally a good idea for a data warehouse?
What is spool space?
Explain the term 'row' related to relational database management system?
In BTEQ, how are the session-mode parameters being set?