1.what is activity count?
2.what is skew factor?
how it's working explain brefily
- 5 Answers
- 31822 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / yuvaevergreen
1. >> activity count indicates the no of rows affected/processed by the last request(no of rows returned to bteq from teradata).
2. >> skewness refers to the distribution of rows on the amps.
>> If some AMPs are having more rows and some very less, then skewness would be high. This would affect the parallelism.
3. Following query gives the skewness for all tables.
SELECT ts.DatabaseName
,ts.TableName
,td.CreateTimeStamp AS Created
,td.LastAlterTimeStamp AS LastAltered
,td.AccessCount
,td.LastAccessTimeStamp AS LastAccess
,SUM(ts.CurrentPerm) AS CurrentPerm
,SUM(ts.PeakPerm) AS PeakPerm,
(100 - (AVG(ts.CurrentPerm)/MAX(ts.CurrentPerm)*100)) AS SkewFactor
FROM DBC.TableSize ts
JOIN DBC.Tables td
ON ts.DatabaseName = td.DatabaseName
AND ts.TableName = td.TableName
GROUP BY 1,2,3,4,5,6;
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
Is multi insert ansi standard?
How would you load a very large file in teradata in general?
Explain the term 'columns' related to relational database management system?
What do you mean by teradata intelliflex?
Explain the term 'row' related to relational database management system?
How is MLOAD Client System restarted after execution?
Difference between inner join and outer join?
Difference between stored procedure and macro?
how can we analyze the locks ?
What are the various indexes in teradata? How to use them? Why are they preferred?
How to select first n records in teradata?
What are tpump utility limitations?
Highlight the need for Performance Tuning.
What is oltp?
There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?
