Hi  labartez,

The simplest way is to use 'with fillfactor=1' in the modify statement.
This doesn't absolutely garuntee one row per page, but it'll gop close in
most circumstances.

The alternative is to add a wide column of nothing to the table so that
each row can occupy only one page, regardless of the fill factor. This
works because the row must not span a page. So making the row width
say 1100 characters in a 2k page will ensure 1 row per page. Make
obvious adjustments for other page sizes.

To see how many rows per page you are getting. The row tid contains
its page and row number. In a 2K page, mod(tid,512) is the row number
and tid/512 is the page number. For a 4k page use 256, 8k use 128
etc...

Martin Bowes

help table table_name will tell you

help table t1\g
Executing . . .

Name:                 t1
Owner:                ingres
Created:              21/08/2006 19:06:28
Location:             ii_database
Type:                 user table
Version:              II9.0
Page size:            2048
Cache priority:       0
Alter table version:  0
Alter table totwidth: 25
Row width:            25               <<<<<<<<<
Number of rows:       4
Storage structure:    heap
Compression:          none
Duplicate Rows:       allowed
Number of pages:      3
Overflow data pages:  0
Journaling:           enabled after the next checkpoint
Base table for view:  no
Permissions:          none
Integrities:          none
Optimizer statistics: none

Column Information:
                                                                 Key
Column Name                      Type       Length Nulls Defaults Seq
i1                               integer         1  yes    null
t1                               varchar        20  yes    null

Secondary indexes:    none