Interested to Buy Any Domain ? << Click Here >> for more details...
1.what is activity count?
2.what is skew factor?
how it's working explain brefily
- 5 Answers
- 33075 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
What is teradata and why it is used?
What does Amp contain and what are all the operations that it performs?
How do you create tables? Exact syntax, and create profiles, users in teradata?
What is called partitioned primary index (ppi)?
Can you connect multiload from ab initio?
My table got locked during mload due to a failed job. What do I do to perform other operations on it?
How many codd's rules are satisfied by teradata database?
How is MLOAD Teradata Server restarted after execution?
In Teradata, how do we Generate Sequence?
What is the difference between fastload and multiload? Which one is faster?
What is smp and mpp platforms?
How many tables can you join in v2r5?
What is the difference between teradata and oracle?
Why is the case expression used in teradata?
Explain BYNET.
