extent size ?
Posted in 1998
Yew Fei — — source: Informix-list mailing list archive (1991-1998)
I have a table with the following structure :
create table bill_trans
(
bill_no integer,
bill_date date,
bill_time time,
bill_item char(40),
bill_amt dec(16,2),
primary key(bill_no)
)
lock mode row ;
Estimation of records per day : 20,000
what is the optimum extent size (first extent size) and next extent size
shall I used to create this table ?
**** Appreciate if you could list down the steps of estimating the
extent size ****