![](//teradataforum.com/imgs/ptdfw1.gif) |
![](//teradataforum.com/imgs/ptdfw2.gif) |
Archives of the TeradataForum
Message Posted: Wed, 03 Aug 2011 @ 12:16:21 GMT
Subj: | | Re: Difference between collect stats on a column vs. a table |
|
From: | | Anomy Anom |
<-- Anonymously Posted: Wednesday, August 03, 2011 08:14 -->
Hi,
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.
| |