Re: extent size ?

ccremid 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?. The extent size for fragmented and detached indexes is the ratio of keysize to rowsize times the next extent size. Art S. Kagel