The number of rows allowed for a DOL data page is determined by:
The page size.
A 10 – byte overhead for the row ID, which specifies a row-forwarding address.
Table 8-6 displays the maximum number of datarows that can fit on 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.
