Re: Extents Sizes

On Wed, 4 Jun 2003 17:34:06 -0400, Jack Parker wrote: > >Growth depends on your environment. If you plan to 'fire and forget' then >several years yes. With an actively monitored/maintained database, I would >plan growth on a quarter or even monthly basis (i.e. YMMV). > >As for sizing There are sizing utilities around - I have an excel >spreadsheet I use. > >cheers >j. Yup, what he said. I guess re-sizing tables on a monthly basis with a 24/7 database and several million rows is pretty well guaranteed to upset the users, so can't be all bad ;-) Plus, how well do the later variants of IDS cope with the "Swiss Cheese" effect in a table where deletes often take place (especially when varchars are present), with regard to intelligently filling the holes - this can cause a spectacularly fragmentary table and hence necessitate a rebuild of the table anyway, regardless of the extent sizing strategy! Malc -- XS2Mail: Check your mail anywhere http://www.xs2mail.com/