Archives of the TeradataForum

Message Posted: Thu, 19 Nov 2009 @ 11:34:00 GMT

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

Yes it's a good practice when you define columns in ascending order with respect to size particularly when you are going to use multi stats.

Multi-Column Statistics: More Effective when Short Columns Come First because Order of columns within the collected statistics will be the same order as in the CREATE TABLE statement.

When varchar columns are present , they are converted to full length before statistics collection. 16 byte interval limit may be exceeded with just the one column. Best when varchar columns appear last in multi-column statistic.

Thanks,

Soumya

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