Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 04 Jul 2006 @ 16:05:34 GMT


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


Subj:   Evaluation of the size of index in a system
 
From:   BERRAFATO J-Michel

Hi,

I'm trying to evaluate de size of the indices in all the databases of the system

My problme tuch essentialy the size of the 'SECONDARY INDEXES' and 'JOIN INDEX'

For me, there is Two methods :

- evaluate the size of the table before, drop the index and doing the substration between the 2 size. For me, in production it is impossible.

- doing a tendance with the evaluation of the size use in the index and the number of row for each table and finaly doing the sum... possible but long...


I want to find a function/macro or a request wich give me easily the good information.


Thanks for your information



     
  <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