Re: TBLSPACE table extents.
Posted in 1996
Barry Leb — — source: Informix-list mailing list archive (1991-1998)
>I try to estimate the growth of the table over some period of time, >say, 3 months, and create the table with the appropriate size >first extent. Then, I calculate what the growth will be in each month, >and define that as the next extent size. >The only way to truly avoid this is to make the first extent HUGE. >But who has enough disk space for that? >I have a formula for calculating the first extent size. If you want >it, please write me back. (I'm at home now at don't have it handy) >P.S. Deleted rows are reused, so I've heard. I am interested in your formula. Barry Leb barryleb@mindspring.com