Archives of the TeradataForum

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

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

<-- 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.

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