Hi,

I always thought, that the fill ratio is corrected to about 80% when
doing a restore. But after my restore, I get the following values for
the biggest table:

RANKINGITEM (154)
Primary pointer page: 186, Index root page: 187
Data pages: 25095, data page slots: 25095, average fill: 59%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 25094
60 - 79% = 0
80 - 99% = 0

The table contains about 7'000'000 records. Most of these will remain
unchanged, but new records will be added in the future.

- should I do a restore with -use_all_space ?
- should I just leave it like this ?
- other suggestion for changing it ?

My page size is 16KB. The table is defined like this:

CREATE TABLE RANKINGITEM
(
RANKINGCLUBID INTEGER NOT NULL,
SORTCODE SMALLINT NOT NULL,
SWIMRESULTID INTEGER NOT NULL,
PLACE SMALLINT,
CONSTRAINT PK_RANKINGITEM PRIMARY KEY (RANKINGCLUBID, SORTCODE)
);


cu Christian