Archives of the TeradataForum

Message Posted: Wed, 30 Sep 2009 @ 09:47:48 GMT

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

Yes, you can!

     Create table ttmp.test1 (a integer, b char(10), c integer) Primary index (a);

You collect stats as -

     Collect stats on ttmp.test1 index (a);
     Collect stats on ttmp.test1 column (b);
     Collect stats on ttmp.test1 column (c);
     Collect stats on ttmp.test1 column (b, c);

Now, you can drop any of the stats collected above.

     E.g. Drop stats on ttmp.test1 column (b, c);
     Or   Drop stats on ttmp.test1 index (a);

Hope this helps.

Thanks,

Lakhwant

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