Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 18 May 2005 @ 20:51:01 GMT


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


Subj:   Collect stats and DBC.indexes.IndexStatistics
 
From:   Line Robert M

All

After running collect stats on indexes I have noticed that the DBC.indexes.IndexStatistics is null even though I have run stats on this particular index.

What I am trying to do is to determine where I have indexes without stats and run stats on those indexes. Problem is that I cannot determine which indexes have stats and which ones do not. Any help would be greatly appreciated.

I have run Dieter's collect stats script that shows when stats where last run but the stats type shows an 'I' which I am assuming is an index is not changing in volume as it should.


Robert Line
(Contractor, NCR)
Certified Teradata Master
DBA AFKS OMS



     
  <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