Archives of the TeradataForum

Message Posted: Fri, 16 Nov 2012 @ 09:25:16 GMT

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

Hi all,

Could you please help me to understand more on performance tuning.

If my table(tables) has stats defined on almost on all the columns (say, 80-90% columns, both single column & multi column stats), I mean, on necessary columns and also may be on unwanted columns, will this affects the performance of my query(queries)?

None of the stats are stale, but the stats are existing on many columns.

Ignoring the cost to collect stats.

Thanks,

Sravan.

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