Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 03 Aug 2011 @ 12:16:21 GMT

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

Subj:   Re: Difference between collect stats on a column vs. a table
From:   Anomy Anom

<-- Anonymously Posted: Wednesday, August 03, 2011 08:14 -->


Collect stats on Table level means that it will collect the stats of all the columns on which stats has already been defined. Internally, it works the same way.

Collect stats on Table level is usually used to avoid the overhead of writing 4 different Collect stats statement (as in your case) and adding more when stats are defined on new columns.

  <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