Find table skew in teradata

To find skew factor for table in Teradata, we can use below query.

 SELECT 

TABLENAME,

SUM(CURRENTPERM) /(1024*1024) AS CURRENTPERM, 

(100 - (AVG(CURRENTPERM)/MAX(CURRENTPERM)*100)) AS SKEWFACTOR 

FROM 

DBC.TABLESIZE 

WHERE DATABASENAME= 'Mydatabase_name'

AND TABLENAME ='myTable_name'

GROUP BY 1;

Simply replace the "Mydatabse_name" and "myTable_name" and run the query.