Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 10 Apr 2009 @ 20:09:13 GMT


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


Subj:   Re: Finding frequency of NUSI usage
 
From:   Rob Paller

Madhu,

There is an access count on the DBC.Indices (or DBC.Indexes) table that can be compared to the access count in DBC.TVM to determine the frequency of usage for a given index. If you search the archives you should be able to find more information on a report/view that was written by another forum member (forgive me as their name escapes me) that does this for you along with some other information.


Hope this helps.

Rob



     
  <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