Archives of the TeradataForum

Message Posted: Tue, 30 Aug 2016 @ 13:07:11 GMT

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

They say the same thing:

- Data matches, stats match.

- Data different, stats don't match, recollect.

The tables will have the same stats collected on the same columns with same stat values. When you copy the stats you copy the values with those stats, regardless of the number of rows in the destination table. If the rows in the source and destination match, no need to recollect. If the rows in the dest table are not the same, you can recollect at the table level:

     COLLECT STATISTICS ON SomeDB.SomeDestTB;

... and you will recollect stats on all the indexes and columns that were recollected.

Not sure what else to describe. Perhaps reading the TD docs will help.

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