Archives of the TeradataForum

Message Posted: Fri, 12 Dec 2003 @ 23:58:08 GMT

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

No.......

Statistics are always collected from the column(s) in the primary subtable. It is not possible (and not really useful) to collect stats on an index subtable.

The dividing point in statistics is whether they are collected on a single column or on multiple columns. Before 5.0.0, it was impossible to collect statistics on multiple columns unless there was a secondary index on that group of columns. As an implementation detail, single column stats (whether you used column or index syntax) are stored in DBC.TVFields while multiple column stats (whether you used column or index syntax) are stored in DBC.Indexes.

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