Archives of the TeradataForum

Message Posted: Wed, 25 May 2005 @ 14:58:56 GMT

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

BG,

Another follow up to this, I have found something that will show you the skew factor for tables within a database. Try this and you might be able to determine which table(s) might be causing your space issue.

     SELECT '' (Title '')
     ,TableName AS Name
     ,'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 6 desc

Note: pay closer attention to the larger space tables as opposed to the smaller ones. The smaller tables may not have enough data to spread evenly, but they also would not be taking up that much space.

Kevin

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