Archives of the TeradataForum

Message Posted: Sat, 31 Oct 2015 @ 21:53:22 GMT

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

<-- Anonymously Posted: Saturday, October 31, 2015 15:54 -->

Hi,

I understand that it is imperative that stats are collected on the Indices of a table. However, does it help to collect statistics on non- index columns (columns which do not appear in any of defined indices of a table) which however are frequently used in Joins and WHERE clauses ?

Please share your thoughts.

Thanks.

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