Archives of the TeradataForum

Message Posted: Thu, 04 Nov 2010 @ 22:05:15 GMT

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

You need another Teradata Expert.

Multi-column stats are not always necessary, but they often help. A good example would be two columns that are not hugely unique individually, but together, their combination are more unique and you are constraining on both those columns. The optimizer may choose a different access path. If both columns are very unique on their own, you may not benefit from multi-column stats.

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