Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 03 May 2012 @ 17:26:54 GMT


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


Subj:   Re: Dropping stats on indexes
 
From:   Pluebell, Fred

Single-column index stats (primary or secondary) are the same as single-column stats. Whether you collect them using the INDEX or COLUMN keyword makes no difference. These stats remain if you drop the index.

If you collect multi-column stats on the same collection of columns that make up an index, again there is no difference which keyword you use. These stats go away if you drop the index.

You can specify COLUMN even when there is no corresponding 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: 23 Jun 2019