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.
