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