![](//teradataforum.com/imgs/ptdfw1.gif) |
![](//teradataforum.com/imgs/ptdfw2.gif) |
Archives of the TeradataForum
Message Posted: Thu, 07 Jun 2007 @ 11:08:08 GMT
Subj: | | Re: Designing wide (fat) tables |
|
From: | | D silva, Joseph Vinish |
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
| |