Archives of the TeradataForum

Message Posted: Fri, 14 Nov 2008 @ 20:55:03 GMT

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

The collection of stats depends on the usage of the index and its definition. Stats on the index of a table which is defined by a UPI would not necessarily be helpful if the table is evenly distributed. Join indexes, NUSI and PPI would be good candidates for stats collection.

Thanks & Regards,

Rajesh Koneru

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