Archives of the TeradataForum

Message Posted: Fri, 28 Oct 2005 @ 13:03:02 GMT

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

<-- Anonymously Posted: Friday, October 28, 2005 08:26 -->

I just found out that I was on a list of people that had quite a few skewed tables.

How do I rectify this issue in the future? I am using a varchar column to contain the customer ID, which is the only unusual thing related to these tables. I am then using insert-select statements to populate the tables.

Below is some sample output from the DBA report, which does not contain all of the columns.

In addition, how can the "space used" and "space reported" values be different?

Thanks in advance for your assistance!

      Space Used      Space Reported    Skew %
       1,929,728         404,324,352         0
     380,443,136         305,823,744        94
       1,142,784             884,736       100

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