>Hi Jim,
>
>So, in essence, this becomes an optimal solution for a table that has a lot of transient records? Like, for example, an open ledger period? Where you are neever going to get more than
n records but the I/O will be high before the period is closed.
Yes, there is also a scholl of thought that the optimal size thing is true for all tables. Basically, for any table in any system there is a size that it will grow to and float at forever. If this is true then there is an advantage to keeping the file contiguous and not changing its size for each delete and add that occurs.