Number of rows per data page

The number of rows allowed for a DOL data page is determined by:

Table 8-6 displays the maximum number of datarows that can fit on a DOL data page:

Table 8-6: Maximum number of data rows for a DOL data page

Page Size

Maximum number of rows

2K

166

4K

337

8K

678

16K

1361

APL data pages can have a maximum of 256 rows. Because each page requires a one-byte row number specifier, large pages with short rows incur some unused space.

For example, if Adaptive Server is configured with 8K logical pages and rows that are 25 bytes long, the page will have 1275 bytes of unused space, after accounting for the row-offset table, and the page header.