Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 16 Dec 2003 @ 20:39:43 GMT


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


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

John,

  When talking about a single-column index, then whether the collect statement is performed on the column or on the index, the two statements are effectively the same thing and whichever one you chose, it only needs to be done once.  



There is a 'CREATE INDEX'-style syntax form for collecting statistics on indexes which takes into account such options as UNIQUE/ALL/ORDER BY. They are not available with the COLUMN version.

Ref: SQL Ref - Vol.4 (May 2003), B035-1101-122A, 3-16, p.504.


Regards,

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: 23 Jun 2019