Archives of the TeradataForum

Message Posted: Tue, 22 Sep 2009 @ 13:57:33 GMT

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

Victor that is correct. You only get the correct (populated) stats if you utilized the WITH DATA statement.

However you can still get the statistical profile (zeroed stats ) If you use a statement like the following:

     Create tableB as tableA WITH NO DATA and statistics;

After you populate the table with whatever data you want, then you can recollect at the table level making this a quick easy solution for replacement of tables or testing environments.

I have used this often in production environments, because you can do additional things like create the table with a different PI, and/or Secondary indices, and PPI. Test the table, then rename.

As long as you understand the caveats like the SET/MULTISET issues, partition stats and some other interesting ones, it is quite a handy addition to V12.

Otherwise the more elegant derivation of Stats statements, using Dieters scripts, or modifications thereof is more flexible.

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