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)].
| 
