Hello,

I would like to know how to calculate extent size of a table starting from the order tbcheck - Pt database:table.
Indeed I make already my table on a machine of test, and then I need extent size to put it in exploitation.

table repor (
rep1 serial,
rep2 char(30),
rep3 char(20),
rep4 date)
=> size 58

index idx1 on repor(rep1);
index idx2 on repor(rep2);

Number of rows = 500000

Thank you very much.

It all depends on teh page size, the growth rate.
Try to estimate the number of pages the table will grow.
Set the extent size in that way that the table will not allocate every day a new extent. Play with it, monitor it. You probably don't need reorganizations.
What version do you use?

Page size= 2048
Growth : at the beginning 150000 and at the end of each month 500000 (when i do a reorganisation)
In fact my table'size is 377 and the version of informix is 5.03.UC1
Thanks