Skew

LOCK Dbc .TableSize FOR ACCESSSELECT TableName AS Name ,'T' AS "Type",SUM (CurrentPerm ) AS CurrentPerm,SUM (PeakPerm ) AS PeakPerm ,(100 - (AVG (CurrentPerm )/MAX (CurrentPerm )*100 )) AS SkewFactorFROM Dbc .TableSize WHERE DataBaseName = 'dbname'AND tablename = 'tbname' GROUP BY 1 ORDER BY 1
 

 

 

SkewFactor < 50 is good.

 

For Volatile table,Deviation between +15% and -15% is good PI.

SEL dt1.a (TITLE'AMP'), dt1.b (TITLE'Rows'), ((dt1.b/dt2.x (FLOAT)) - 1.0) * 100 (FORMAT'+++9%',TITLE'Deviation')FROM ( SEL HASHAMP( HASHBUCKET( HASHROW(pc_code) ) ) , COUNT(*) FROM VT_GEO a GROUP BY 1)dt1 (a,b) ,( SEL (COUNT(*) / (HASHAMP()+1)(FLOAT)) FROM VT_GEO a)dt2(x)ORDER BY 2 DESC,1;