Home Page for the TeradataForum

Archives of the TeradataForum

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

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

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

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023