Archives of the TeradataForum

Message Posted: Tue, 26 Sep 2006 @ 17:11:11 GMT

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

No, it does not make a difference if you use the COLUMN or INDEX form of COLLECT. (Try it!)

If you collect stats on a single-column index or on that one column alone, the stats remain if you drop the index. If you collect stats on a multi-column index, or on a matching list of columns, the stats go away if you drop the index.

The only time it matters is if you first collect multi-column statistics and then define an index with the same set of columns. In that case you can't collect stats using the index form until you drop the column stats.

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