Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 16 Dec 2003 @ 21:57:55 GMT


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


Subj:   Re: Collect Stats on Single Column SI
 
From:   Victor Sokovin

Fred,

  Permitting additional keywords in the syntax of the COLLECT STATS statement does NOT cause the method of collection or the resulting stats to be any different from the other syntax form.  


The syntax diagram offers a large number of combinations because most building blocks are optional: USING SAMPLE (yes/no), index name (yes/no), number of columns in column_name_1 and column_name_2 and the options I mentioned before. If all these combinations lead to the same statistics then what was the ispiration behind this command?


  Note the "Advantages of the CREATE INDEX syntax" section a few pages later in the manual...  


Found the paragraph. Do you read it like the only real advantage is that you can collect stats on a few indexes in one statement? If so, why?


Victor



     
  <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