Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 26 Jun 2014 @ 16:11:09 GMT


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


Subj:   Re: How to calculate the space consumed by Secondary index
 
From:   Newell, Ray

You can use the Ferret showblocks/l command or the collect demographics command. The collect demographics will insert data into a QCD database and then you can use the datademographicsview to select columns. Both the utility and command will display data by subtableids. With the ferret utility look at the number of data blocks times the average block size.

With the collect demographics command, use the average row size times the number of rows.



     
  <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