Archives of the TeradataForum
Message Posted: Mon, 20 Oct 2003 @ 16:49:02 GMT
| 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)].