Was this helpful?
Calculate Space Requirements When Rows Span Pages
Follow these steps to determine the amount of space needed to store the data in a table with rows that span pages:
1. Determine the number of pages per row, as follows:
pages_per_row = row_size / max row size
where max_row_size is the maximum row size for the table, as shown in Maximum Row Size Per Page Size.
Round up to the nearest integer.
2. Determine the number of data pages needed for the table, as follows:
data_pages = num_rows * pages_per_row
Maximum Row Size Per Page Size
Table rows span pages if the row size is greater than the maximum row size for the table page size, as shown in this table:
Page Size
Max Row Size
Page Header
2048 (2K)
1928 bytes
120
4096 (4K)
3976 bytes
120
8192 (8K)
8072 bytes
120
16384 (16K)
16264 bytes
120
32768 (32K)
32648 bytes
120
65536 (64K)
65416 bytes
120
Last modified date: 04/03/2024