Archives of the TeradataForum

Message Posted: Fri, 27 Jun 2003 @ 23:53:38 GMT

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

If you have previously collected statistics on all columns, then

collect statistics ;

will collect statistics on all those columns again. It won't run any faster or slower. This is a convenience feature, not a performance feature. We once looked at running all the collects in parallel but found that sometimes the spool usage was excessive.

Jon

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