Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 16 Dec 2003 @ 22:17:14 GMT


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


Subj:   Re: Collect Stats on Single Column SI
 
From:   Fred W Pluebell

USING SAMPLE does in fact change the method of collection (using either syntax).

Personally, I find it a "real advantage" to be able to copy & paste the CREATE INDEX statement and do only minor editing instead of using entirely different syntax for COLLECT STATS. But apart from that, the only benefit is that you can collect statistics for multiple indexes in the same statement / unit of work.



     
  <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