Archives of the TeradataForum

Message Posted: Fri, 12 Dec 2003 @ 23:43:33 GMT

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

Table column and index are two distinct physical database objects. Their stats also. COLLECT STATS COLUMN, for instance, might not be enough to make the optimizer use the index in situations where the index can potentially be used. COLLECT STATS INDEX will be better in such cases.

Victor

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