Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 26 Sep 2006 @ 15:13:57 GMT


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


Subj:   Re: Statistics expert needed
 
From:   Barner Eric

That is only true from the Optimizers perspective.

However, if you collect STATS on an INDEX and the Index is dropped, the statistics are dropped with it.

If you collect Stats on a column(s), that so happens to be an index, if the index is dropped, the column stats stay.

And can be refreshed with out rebuilding an index.



     
  <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: 15 Jun 2023