LOCK Dbc .TableSize FOR ACCESS SELECT TableName AS Name ,'T' AS "Type" ,SUM (CurrentPerm ) AS CurrentPerm ,SUM (PeakPerm ) AS PeakPerm , (100 - (AVG (CurrentPerm )/MAX (CurrentPerm )*100 )) AS SkewFactor FROM 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;