Archives of the TeradataForum

Message Posted: Wed, 25 May 2005 @ 15:13:55 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

You can remove 2 of the selected columns, which are used internally by Teradata Administrator. (where this SQL obviously came from)

So the SQL becomes:

     SELECT TableName AS Name
     ,SUM(CurrentPerm) AS CurrentPerm
     ,SUM(PeakPerm) AS PeakPerm
     ,(100 - (AVG(CurrentPerm)/MAX(CurrentPerm)*100)) AS SkewFactor FROM
     Dbc.TableSize WHERE DataBaseName = ''
     GROUP BY 1
     ORDER BY 4 desc

A perfectly distributed table will have a Skew of 0.

A table that is entirely on one AMP will be close to 100.

As Kevin said - you can ignore any small tables.

Mike Dempsey
Teradat Client Tools

	<Prev	Next>		<<First	<Prev	Next>	Last>>