Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 20 Oct 2003 @ 16:49:02 GMT

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

Subj:   Re: Space usage
From:   Terry Stover

For quick & dirty cost-benefit analysis you can use an 8 bytes/row thumbrule for nusi sizing. I did some significant testing earlier this year and found 8.1 to 8.7 bytes per row. I think it goes to 10 bytes/row for R5.

The formula (from Physical Implementation class notes)is: Row count * 8 + [(number of distinct index values) * (index value size + 20 ) * MIN (# of amps, rows per value)].

  <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