Archives of the TeradataForum

Message Posted: Thu, 19 Aug 2010 @ 08:41:11 GMT

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

Skew for a table means Uneven AMP Distribution of data in table.

Skew factor can be table level and CPU level.

Skew factor is major for the table. Less skew will increase the performance of the table.

To find out the Skew factor for the table :

     select databasename,tablename,
     cast((100 - (AVG(a.CurrentPerm)/MAX(a.CurrentPerm)*100)) as integer) AS SkewFactor
     From dbc.tablesize a where databasename='DatabaseName' and
     tablename ='TableName' group by 1,2 order by 1;

Regards

Chanderbabu Veppala

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