Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Skewed tables and VARCHAR column
 
From:   Anomy Anom

<-- 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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023