Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Mon, 15 Sep 2008 @ 16:02:54 GMT


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


Subj:   Re: Calculating total space for indexes
 
From:   Rob Paller

I am pretty sure you can use the ferret utility to accomplish this. (It has been discussed in past threads available on the TeradataForum's website) The manuals also refer to a formula that can be used to calculate this by hand (or with the help of a spreadsheet).

I have not yet found or perfected a method using SQL to accurately determine a NUSI index size. I imagine it can be done based on the information in the data dictionary and profiling the data to obtain both cardinality and the average length of variable width data. USIs should be pretty straight forward in SQL using the formula's in the manuals.


HTH



     
  <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: 28 Jun 2020