  |  
  |  
 
Archives of the TeradataForum 
 
 
Message Posted: Tue, 24 Jul 2012 @ 09:21:11 GMT 
 
  
 
 
 
 
  
|  Subj:  |   |  Re: Collect stats on tables rather than columns  |   
|     |   
|  From:  |   |  Pluebell, Fred  |   
  
 
 
  
The Teradata COLLECT syntax that includes only the table name without any column / index specifications indicates that you want to re-collect
(refresh) all previously collected column / index statistics.  There are no "entire table" statistics as such.  If you attempt to use the "table
only" form before any column / index statistics have been collected, you will get an error. 
 
 
 
 
   
 
 |   |