Archives of the TeradataForum

Message Posted: Wed, 03 Aug 2011 @ 14:20:56 GMT

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

1.Stats is basically a facility available to DB optimizer to understand the demography/distribution of the data to come up with better plans.

2.It does consume space and time when ever collected.

When you have tomany columns and you obviously dont want to miss out on any column you could collect stats on the table(which covers all cols). But then when you know which columns are most frequently used in query conditions, then you can collect stats on the specific columns alone.

-Narayan

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