Archives of the TeradataForum

Message Posted: Thu, 03 May 2012 @ 17:26:54 GMT

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

Single-column index stats (primary or secondary) are the same as single-column stats. Whether you collect them using the INDEX or COLUMN keyword makes no difference. These stats remain if you drop the index.

If you collect multi-column stats on the same collection of columns that make up an index, again there is no difference which keyword you use. These stats go away if you drop the index.

You can specify COLUMN even when there is no corresponding index.

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