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
Why managing the data is important?
Describe the set operators in teradata.
What are some commonly used bteq scripts?
What is the use of teradata system software?
What is multi insert?
Explain the term 'foreign key' related to relational database management system?
What do you mean by fastexport in teradata?
What are the joins in teradata?
What is meant by a Least Cost Plan?
Why do you get spool space errors? How do trouble-shoot them?
Describe primary index in teradata?
Highlight the points of differences between the database and user in Teradata.
Highlight the differences between Primary Key and Primary Index.
What is meant by a Parsing Engine?
In the Primary Index, what is the score of AMPs that are actively involved?