Following an earlier post on skew calculation at table level
will it be correct to calculate the skew at the database level using the following query ?
,SUM(CURRENTPERM/(1024*1024)) AS CURRENTPERM_IN_MB
,SUM(PEAKPERM/(1024*1024)) AS PEAKPERM_IN_MB
,MAXPERM/(1024*1024) AS MAXPERM_ALOTD_IN_MB
,(100 - (AVG(CURRENTPERM)/MAX(CURRENTPERM)*100)) AS SKEWFACTOR
DATABASENAME = 'XYZ'
GROUP BY 1,4;
looking forward for the inputs
No. It will not be correct to check Skew at Database level.
Skew factor makes sense at a Table level and not at Database level, because Skew is determined by the PI chosen for each table and the data that is present in the table.