Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 07 Sep 2001 @ 15:33:17 GMT


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


Subj:   Re: Raw data size
 
From:   Ruth Fenwick

Thanks to those that replied.

I was looking for an easy way of determining Raw data either at the system level or database level. There are far too many tables to look at individually.

What I ended up doing to going back to our ARCHIVE jobs and pulling out the information from there. The bytes and rows archived that are reported are valid and do not include the bytes for the indexes.

What I did find interesting was the amount of space being used by my indexes. On some tables with 3 NUSI, the space used was another 80% more! Something I'll have to investigate.

Ruth Fenwick
IA&DSS Team Leader
Information Resource Management
Hudson's Bay Company



     
  <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: 27 Dec 2016