Archives of the TeradataForum
Message Posted: Fri, 28 Oct 2005 @ 13:03:02 GMT
<-- 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
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|