Archives of the TeradataForum

Message Posted: Thu, 16 Apr 2009 @ 13:12:03 GMT

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

The same stats are always stored in the same place, regardless of whether the COLLECT STATS says INDEX or COLUMN - assuming the index exists at the time you do the COLLECT (so the INDEX form is valid).

The only real difference is in a fairly unusual situation. If you first collected stats on a list of COLUMNS for which there was no corresponding index, then subsequently created such an index, you must either continue to use the COLUMNS form or explicitly DROP the non-indexed COLUMN stats. The INDEX form doesn't allow you to update the non-indexed (IndexType 'M') rows in DBC.Indexes.

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