Query to find skew factor of a particular table? SELECT TABLENAME ,SUM(CURRENTPERM) /1024/1024 AS CURRENTPERM, (100 - (AVG(CURRENTPERM)/MAX(CURRENTPERM)*100)) AS SKEWFACTOR FROM DBC.TABLESIZE WHERE DATABASENAME= <DATABASENAME> AND TABLENAME =<TABLENAME> GROUP BY 1;
Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!