Archives of the TeradataForum

Message Posted: Wed, 03 Aug 2011 @ 12:14:48 GMT

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

Hi,

Collecting stats on table level refresh all the columns in the table.

LIKE:

     collect stats on TABLE1;

Whereas collect stats on a particular columns refresh only that particular column.

     collect stats on TABLE1 column(A);
     collect stats on TABLE1 column(B);
     collect stats on TABLE1 column(C);
     collect stats on TABLE1 column(D);

Regards,

Surekha M

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