Re: extent size ?

At 09:52 AM 07-07-98 -0400, you wrote: >Clem Akins wrote: >> >> At 11:30 PM 02-07-98 +0800, Yew Fei wrote: > ><snip> > >> > >> >what is the optimum extent size (first extent size) and next extent size >> >shall I used to create this table ? > ><snip> > >> > >> I like to set the first extent size sufficient to hold the >> entire table's data (records per day * days required to store) >> and set the next extent size to a similar value even though it >> won't be used for next extents--it is used for other parameter >> sizing by the engine. >> >Excuse my ignorance, but, could you please expand on: >What "other parameter sizing by the engine" are you referring to?. > >TIA > >Tino The next extent size for detached indexes. These are calculated using values including the rowsize, key value size, and next extent size. See the System Administrator's Guide for a fair explanation of how indexes are sized. _____________________________________________________________ Clem Akins (aka clem@informix.com) Menlo Park x5937 Customer Course Development Manager Informix Software, Inc Last seen: "Where the heavens meet the earth", atop Mt Shasta