Archives of the TeradataForum

Message Posted: Wed, 03 Aug 2011 @ 12:37:44 GMT

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

Hi,

My understanding is the COLLECT STATS ON TABLE will only collect the statistics on columns in the table which have previously had statistics collected.

So from your example of TABLE1 with columns A,B,C,D: If you had previously collected individual statistics on columns A and B but not C and D and later performed COLLECT STATS ON TABLE TABLE1, the statistics would be updated on columns A and B but not columns C and D.

A recommendation is to perform a collect stats on the columns of even an empty table since later after data has been loaded into the table a collect stats on table can be used to update all the statistics without having to update statistics on the individual columns.

Nathan

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