Archives of the TeradataForum

Message Posted: Thu, 07 Jun 2007 @ 11:08:08 GMT

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

Normally these large tables are also designed with compression on some of the columns in mind. The bummer being that once you have too many columns, your table header increases in size, and then the number of values you can acutally compress reduces (as they need to be there in the table header, which is of fixed size). I am not sure on the size of table header and whether it has improved in later releases, but yeah it used to be a common occurrence in the past to see a table header overflow with too many cols+compression+indexes ...... So that would be one silent beast I would recommend you to watch for. (sometimes the pure motivation on going for a flat table is to avoid joins and make use of compression in storing those extra columns, a noble desire)

That's my $0.02 on this.

Joseph D'silva

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