 |
 |
Archives of the TeradataForum
Message Posted: Wed, 02 Apr 2003 @ 09:11:58 GMT
| Subj: | | Re: What is Skew factor? |
| |
| From: | | Dieter N�th |
Venkat wrote:
| | What is skew factor? When i see the space summary for table (right click on a table on WINDDI), there is once column called
SkewFactor. | |
It's information about how much more more data (in percent) is stored on the AMP with the maximum permspace compared to average
permspace for that table.
Press F12 in WinDDI and look at the SQL:
SELECT '' (Title ''),TableName,'T' AS "Type",SUM(CurrentPerm) AS CurrentPerm,SUM(PeakPerm) AS PeakPerm,(100 -
(AVG(CurrentPerm)/MAX(CurrentPerm)*100)) AS SkewFactor FROM Dbc.TableSize WHERE DataBaseName = ? GROUP BY 2 ORDER BY 2
Dieter
| |
