Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 16 Dec 2003 @ 20:07:08 GMT

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

Subj:   Re: Collect Stats on Single Column SI
From:   John Hall

I don't understand what you mean when you say that "it goes on to recollect on the index".

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.

  <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: 28 Jun 2020