Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 10 Apr 2009 @ 20:10:32 GMT


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


Subj:   Re: Finding frequency of NUSI usage
 
From:   Linda_Wood

Hello,

Thanks for sharing this query as I too would like to find out if the secondary indexes are being used. However, why is my accesscount always zero? Is there something to turn "on" to collect the count? If so, the DBAs are unaware.


Thanks,

Linda


     select
               tablename,
               indexname,
               indextype,
               sum(case when accesscount  is null
                        then 0
                        else accesscount
                        end) as accesscount
     from
               dbc.indices
     where
               databasename = 'myDatabase'
     group by
               1,2,3


     
  <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