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
- 32882 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / vinay sir(datawarehousing tech
ActivityCount:The number of rows processed in the previous
sql statement it defines.
EG: if there is a table party is having 14 rows then
SELECT * FROM PARTY;
.ACTIVITYCOUNT= 14
Skewfactor:
It tells the distribution of the rows.
-->If uniformly distributed(normal distribution) skew
factor is 0.
-->Skew factor is the reversal of Parallel efficiency.(if
skew factor is 10 then parallel effciency is 90).
There is aformula to identify the skewness.
Please find the below.
SELECT TableName,SUM(CurrentPerm) AS
CurrentPerm,SUM(PeakPerm) AS PeakPerm,(100 -
(AVG(CurrentPerm)/MAX(CurrentPerm)*100)) AS SkewFactor
FROM Dbc.TableSize
WHERE DataBaseName = 'VINAY'
GROUP BY 1 ORDER BY 1
| Is This Answer Correct ? | 13 Yes | 2 No |
Post New Answer View All Answers
What is spool space? Why do you get spool space errors?
What are differences between teradata and ansi session modes in teradata?
What is basic teradata query language?
If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?
Describe the between keyword in teradata?
What is TPD?
What happens when a node suffers a downfall?
Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A
How many sessions of MAX is PE capable of handling at a particular time?
What are some primary characteristics of teradata?
What are the available join types in teradata?
How do you set the session mode parameters in bteq?
What is upsert statement in teradata?
What is meant by a Channel Driver?
What is meant by a Clique?
