1.what is activity count?
2.what is skew factor?
how it's working explain brefily
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 node? How many nodes and amps used in your previous project?
What is teradata? Also, list out some of the primary characteristics of teradata.
Explain some differences between mpp and smp?
What are the frequently used data types in teradata?
How do you set the session mode parameters in bteq?
What are the various indexes in teradata? Why are they preferred?
Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?
What can be achieved by using the teradata rdbms?
What are the available join types in teradata?
Differentiate database data and data warehouse data?
If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?
What are the design features involved in teradata?
How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .
How to Extract data from multiple legacy systems?
How you will check the version of teradata?